Hiding uncalculated values
=IF(COUNT(C5:C6)=2,C6-C5,"")
--
Regards,
Peo Sjoblom
"JET" wrote in message
...
I am performing a simple calculation formula with a fixed number in C5.
The
formula is =C6-C5.
Even when there is no value in C6 the answer shows up a the same number in
C5.
How can I hide something other than 0?
25
-x
=25 <--This needs to be blank.
John
|