Excel: Is there a plus/minus function that I can use?

[Bird222]

I would like the following formula to evaluate to true if it is within .01 over or under.

=(A1+B1)=1400

For example

If A1+B1= 1399.99 the formula above returns true.
or A1+B1= 1400.00 the formula returns true (obviously)
or A1+B1= 1400.01 the formula returns true

Is there a way I can do this?

 

[mpo]

=ABS(1400-(A1+B1))<=0.01
Will return a true or false statement for your tolerance.