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