On 06/18/2010 06: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.
>
> = IF(AU238>1, 1)
> + IF(AV238>1, 1)
> + IF(AW238>1, 1)
> + IF(AX238>1, 1)
> + IF(AY238>1, 1)
>
> 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
Did you try?
=IF(AT238-AT196<>0, AT238-AT196, " ")        (" " = double-quote, space,
double-quote)
This says that if the sum is not equal to zero then print it,
other wise print nothing.


Tom

-- 
"PC, "Where would you like to go today?" ... 
Mac, "Where would you like to be tomorrow?" ... 
Linux, "Are you guys coming, or not?""


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to