Al, Change
IF(A1>0;10;'too small") to =IF(A1>0;10;"too small") and it should work for you (that is, make sure to use " and not ' to open and close the string .... and of course, don't forget the = .... kennM On 6/4/07, Al Brown <[EMAIL PROTECTED]> wrote:
I am using Open Office 2.2 and have the following problem: I have tried to use an 'IF' statement in an Open Office spreadsheet. I did a cut-and-paste on the Help File <IF(A1>0;10;'too small")> example and even that does not work. I put the statement in B2 and entered 12 in A1 with no results. Please help. I really need that IF statement. Al Brown [EMAIL PROTECTED]