help
=IF(J5="","",J5-4)
--
Gary's Student
gsnu200705
"Justin Kline" wrote:
how do you either hide the values of formulas in cells until the formula is
calculated? Let me explain, i have done a simple calculation (=J5-4) however
this results in the value of -4 until a new value is enetred. How do you
stop it from calculating the result straight away (or when the current value
is blank / zero)
or secondly how can you hide negative values in cells?
if you can assit that would be appreciated
Justin
|