Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign a default value
I am trying to create an estimate sheet for my service shop, I have formulas
that add totals, however I have other formuals that multiply the quantity of a part by the price. when I don't uses those lines I have to go through and enter a zero in everythime to correct the formula error. is ther anyway to set that when there is nothing in the cell it automatically goes to a value of zero? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the Insert Row / Column Default | Excel Discussion (Misc queries) | |||
Setting default font and colour | Excel Discussion (Misc queries) | |||
Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
Setting and KEEPING the default chart | Charts and Charting in Excel | |||
how do i set default font / text size in comments? | Setting up and Configuration of Excel |