Subtracting Text from Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
Something like this may work for you. This assumes B1 is being subtracted
from A1.

=IF(NOT(ISNUMBER(B1)),A1,A1-B1)

HTH,
Paul
 
A1=Number
B1=Text

TRY:

=IF(ISNUMBER(B1),A1-B1,A1)

If either column can be text, then adapt the above

HTH
 
.... and PLEASE only post on ONE forum to avoid people wasting time answering
postings which have been answered elsewhere.
 
Back
Top