On 6/18/2010 6:29 PM, Wade Smart wrote:
Im working on updating some forms and Im having trouble with one of the
cells.
=IF(AT238-AT196=0,"", AT238-AT196)
If this cell has a value of 0 then print nothing, else, print the value.
I would suggest familiarizing yourself with the help files in Open
Office. There are differences from Excel that can kill your formulas.
The correct syntax for the IF function in Open Office is;
IF(Test; ThenValue; OtherwiseValue)
Note the use of the semicolon instead of the comma. Re-write you
formula as =IF(AT238-AT196=0;"";AT238-AT196) and see if that works.
= IF(AU238>1, 1)
+ IF(AV238>1, 1)
+ IF(AW238>1, 1)
+ IF(AX238>1, 1)
+ IF(AY238>1, 1)
These make no sense. The IF statements are all missing an argument and
would return an error. You need to use semicolons and get rid of extra
spaces and add the third argument (ie. ;""). In attempting to enter the
+IF statements you have above Open office just adds the = sign and acts
like the first one. ??
And then I have a column (actually multiples of columns) that talleys
the results.
The problem is Im getting 5 every time even though some cells are empty.
Does "" not mean the same as nothing or null?
Wade
Perhaps an explanation of what you are attempting might help.
--
Gene Young
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]