Show - in cell
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?
|