| 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)? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Text from Number
Something like this may work for you. This assumes B1 is being subtracted
from A1. =IF(NOT(ISNUMBER(B1)),A1,A1-B1) HTH, Paul " wrote in message ... 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)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Text from Number
=N(A1)-N(B1)
-- Regards, Peo Sjoblom " wrote in message ... 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)? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Text from Number
A1=Number
B1=Text TRY: =IF(ISNUMBER(B1),A1-B1,A1) If either column can be text, then adapt the above HTH " wrote: 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)? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Text from Number
.... and PLEASE only post on ONE forum to avoid people wasting time answering
postings which have been answered elsewhere. " wrote: 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)? |
| Reply |
| 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 | |||
Linear Mode
