How to Hide Negative Numbers

[Marilyn]

Hello,

I have a formula in Column C which subtracts a number in the previous sheet
plust a number in the current sheet. When I copy the formula I get negative
numbers because some of the cells in the current sheet are not yet populated.


Is there a way to hide the negatives numbers displaying in the column and
have the results show up once I populate the numbers in the cells the formula
is using?

Thanks,

 

[Peo Sjoblom]

=IF(A2-B2<0,"",A2-B2)

replace A2 and B2 with the cells you are using

you can also use a custom number format like

0.00;;

If there will never be any negative numbers when both cells have values


--


Regards,


Peo Sjoblom

 

[FSt1]

hi
here's a commonly used trick.
=if(B7<0,"",B6+c6)
the cell addresses are made up but it illistrated the point. if the cell in
question is negative, the if formula will hide the results until positive.
adjust the cell references to suit your data.

regards
FSt1

 

[Peo Sjoblom]

0.00;

might be better since the other format hides zero as well

--


Regards,


Peo Sjoblom

 

[Marilyn]

Thank you ALL for the quick response. It worked out perfectly.

Have a Great Weekend.