can I get cells with a minus number to show zero

M

marcus1066

I have a cell which has a basic formula in (adding up from 2 other cells)
This number can end up being a minus number (-167), If this happens I need to
be able to make that minus number appear as a zero (0). Is this possible?
please help.
 
B

Bob Phillips

If you want to retain the underlying value, but just show the 0 value, use a
format like General;\0
 
C

CLR

Re-write your formulas by wrapping them in an IF statement that requires the
result to be greater than or equal to zero, like.....

=IF(YourFormula<0,0,YourFormula)

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top