How do i subtract cells in an IF function?
 

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.

How do i subtract cells in an IF function?
 

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




"Ryan" wrote in message
...
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.