How do i subtract cells in an IF function?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top