On Monday June 04 2007 8:08 pm, Kenn Murrah wrote: > 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]
Copy to Al. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]