Show - in cell

A

ambermw15

I have some formulas in a couple of cells but I don't want them to calculate
yet. Some other cells are dependant on it and I would like it to show a - in
the cell. The situation is that it deals with inventory for a place that
sells vehicles. I don't want trade in cars to calculate until they are sold
because it shows a loss. Or maybe I'm doing the calculation wrong. I don't
think it should be that I need to delete the formulas until that vehicle is
sold because then I have to input them again later and it is a hassel. How
do I make the cells dependant on more than just the ones in the formula?
 
R

Roger Govier

Hi

Assuming Purchase in A1, Sale in B1 and Margin in C1
Enter in C1
=IF(B1="","",B1-A1)
which is saying if B1 is empty (no sale has taken place) so show nothing
in the cell with the formula, otherwise show the result of subtracting
the value in A1 from the value in B1
 
Top