How to Hide Negative Numbers

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

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,
 
=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
 
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
 
0.00;

might be better since the other format hides zero as well

--


Regards,


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

Have a Great Weekend.
 
Back
Top