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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting Text from Number 6
NumberFormat for small non-zero numbers? 2
subtract entries from allocated total until it reaches zero 1
Excel Subtracting multiple columns from another column 3
With F1 value, look at A, if match or partial match return B 5
Subtracting data when copied from a IE screen 2
Adding and subtraction 2
Add/Subtract columns from tab to tab in same file 3

Back
Top