Cells display nothing IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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;;
 
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!
 
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!
 
If you only want to hide the negative number you can use my solution
You need to do format>cells>number and select custom and put in either
General; or 0.00;

You can also change your formula to

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),0)

or

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),"")

depending on if you want zero or blank
 
Back
Top