Cells display nothing IF

[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?

 

[Guest]

Hi,

Try something like below:

=IF(your formula<0,"",yourformula)

Thanks,

 

[Peo Sjoblom]

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;;

 

[Guest]

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!

 

[Guest]

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!

 

[Guest]

try =if(days360(B274,L274)<=0,"",days360(B274,L274))

 

[Peo Sjoblom]

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

 

[Guest]

It tells me I have an inconsistent formula. Maybe it's not possible...?

 

[Guest]

That did it! THANK YOU!!!! I appreciate all of your help!