| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Text from Number
I am working in a large spreadsheet and need to be able to subtract to
columns without adding any new columns or using subtotals. If I have words and numbers in the columns, ex. "none", is there a function that will eliminate the "value" error message when I subtract (ex. 9-none = value, but i want none or any text to be viewed as zero)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula for subtracting from a negative number | Excel Discussion (Misc queries) | |||
| trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
| subtracting a constant number to all cells in the same column | Excel Discussion (Misc queries) | |||
| Subtracting based on number of miles | Excel Discussion (Misc queries) | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Threaded Mode
