How do i subtract cells in an IF function?

G

Guest

When using an IF function, how do you eliminate the #VALUE when you try to
subtract one cell from another cell. The #VALUE sign appears in the cell with
the formula.
 
P

Peo Sjoblom

It's because one or more cells in a calculation are text and not numbers or
blanks like "" or " "
=IF(ISTEXT(A2),0,B2-A2)

--
Regards,

Peo Sjoblom

Portland, Oregon
 

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

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
need to subtract one cell from each cell in a row 1
multipule calculations in a single column 2
excel 2003 subtract function 2
subtract one cell from each cell in a range and count instances 2
subtract a single cell from range of cells and then count 8
Subtracting data when copied from a IE screen 2
text if negative value 2

Top