Hello,

I have three columns of values and on each row I would like to know if they differ from each other by more than 20%.

For example:

Column A Column B Column C Column D
First Second Third Differ?
100 95 105 No
100 70 105 Yes

It doesn't matter which one is higher or lower. Basically I want to know IF ( |A-B|/A > 0.2 OR |B-A|/B > 0.2 OR |A-C|/A > 0.2 OR |C-A|/C > 0.2 OR |B-C|/B > 0.2 OR |C-B|/C > 0.2 )

I wasn't sure if there was a more elegant solution than the Excel equivalent of the above IF statement. Many thanks for your time.