Show - in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Acoustics - 80Hz loss in car! 0
How do I hide a value in my totals worksheet ? 1
Error: Value in Formula of wrong data type 0
Excel Assistance with Fomula 0
zero value in cell 2
Why do Excel cells not calculate until I hit "save" 2
how do i format a cell to use text and formulas 3

Back
Top