| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Default numeric value
I am creating a spreadsheet dealing with dollars. There are several formulas
that I have created using percentages. One particular formula multiplies a percent in one cell by the $ value in another. If I have no $ value in the cell the formula uses a '1' instead of what I would expect '0'. How can I set up my sheet so that if a cell is blank the default value will be '0'? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extrapolate numeric values from text string | Excel Worksheet Functions | |||
| Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
| Setting and KEEPING the default chart | Charts and Charting in Excel | |||
Threaded Mode
