I am trying to compare three cells containing numbers. I would like the result of the function to display text if any of the values differ from the others by + or - 20 points.
Example:
C1 855 This number 20 points lower than the first or second number, but could be 20 points higher.
C2 875
C3 875
I have a partial function that works comparing one of the numbers.
=IF(C1<=C2-20,"Valve Leakby",IF(C1>=C2+20,"Valve Not Open",IF(C1<>C2+20,"")))
Bookmarks