Cells display nothing IF
The formula in my cells is :
=DAYS360(B274,L274)
I keep getting an error when I try to do something different. Is this
possible?
Thank you so much!
"Peo Sjoblom" wrote:
Custom format
General;
will only display zero and greater
using the same for a 2 decimal number format
0.00;
add a semicolon to the end if you don't want to display zero
0.00;;
--
Regards,
Peo Sjoblom
"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?
|