Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|