-2

I have values in cells A3 and A2. I will be subtracting the value of A2 from A3. What I need is to be able to highlight or flag the result if the difference is greater than an absolute value of .01 from A3.

For example:
29.92-29.90= .02 (Flag)
29.92-29.95= -.03 (Flag)

Improve this question
3
  • You might want to search next time. Found this as first result in google: chandoo.org/wp/2010/06/24/between-formula-excel
    – LPChip
    Sep 16, 2014 at 21:26
  • @Jill You're trying to determine whether the result of A3 minus A2 is greater than .01 difference in absolute value? Example: 1.02 minus 1.01 = .01, which is not flagged, but 1.05 minus 1.01 = .04, which is flagged?
    – James Brewer
    Sep 16, 2014 at 21:29
  • Are you dealing with altimeter settings with these numbers?
    – wbeard52
    Sep 17, 2014 at 1:11

1 Answer 1

Reset to default
2

The answer to the question as interpreted is as follows:

=IF(ABS(A3-A2)>0.01,"Flag","No Flag")

This statement declares that if the absolute value of the result of A3 minus A2 is greater than .01 (negative or positive), then flag it. If the absolute value of the result is 0 or .01, then don't flag it.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .