View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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