ExcelBanter - Hiding uncalculated values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hiding uncalculated values (https://www.excelbanter.com/excel-worksheet-functions/193195-hiding-uncalculated-values.html)

Jet

Hiding uncalculated values

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

Peo Sjoblom

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

All times are GMT +1. The time now is 11:04 AM.