Thread: Show - in cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ambermw15 ambermw15 is offline
external usenet poster
 
Posts: 1
Default 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?