Formula that Ignores Values less than 1

H

Herman Merman

I have a formula that compares two values in separate worksheets. I
the difference between the two values is between -5 and +5 I want th
formulat to ignore it, if it is greater than -5 or +5 I want an "ERRO
- Does not balance" message to show in the cell.

I have tried with IF / OR statements but can't figure out the syntax
can anybody help?

Thank
 
B

Ben

Hi Herman,

It might be better as =IF(ABS(A2-A3)<5,"","Error - does not balance") as it will then display an empty cell rather than 0
 
D

David McRitchie

There is also the OR Worksheet Function
and the AND Worksheet Function for when you don't
want to just check an absolute value.
 
Top