help
 

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

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

help
 

spot on, many thanks

"Gary''s Student" wrote:

=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

help
 

You are very welcome.
--
Gary's Student
gsnu200705


"Justin Kline" wrote:

spot on, many thanks

"Gary''s Student" wrote:

=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