Formula that Ignores Values less than 1

  • Thread starter Thread starter Herman Merman
  • Start date Start date
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
 
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
 
There is also the OR Worksheet Function
and the AND Worksheet Function for when you don't
want to just check an absolute value.
 
You must log in or register to reply here.

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

Condition formula 2
Scrabble Value calculation for Welsh words 0
formula IF > AND < 2
Help with conditional formula for greater/less than 3
if less than greater than 6
Formula Help 2
help with formula 1
convert "less than" value from ppb to ppm 2

Back
Top