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




"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,

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,

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,

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,