How to Hide Negative Numbers
 

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,

How to Hide Negative Numbers
 

=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




"Marilyn" wrote in message
...
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,

How to Hide Negative Numbers
 

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

"Marilyn" wrote:

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,

How to Hide Negative Numbers
 

0.00;

might be better since the other format hides zero as well

--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=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




"Marilyn" wrote in message
...
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,

How to Hide Negative Numbers
 

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

Have a Great Weekend.

"Peo Sjoblom" wrote:

0.00;

might be better since the other format hides zero as well

--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=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




"Marilyn" wrote in message
...
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,