| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating a cell .. to Show Nothing .. if True | Excel Worksheet Functions | |||
| =IF cell needs to show blank if blank | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
