I don't think that this is cleaner--but maybe your boss will understand it???

=if(abs((G11-H11)/G11)<0.01, .....

(no need to do abs(0.01), though)

Dave F wrote:

The formula above tests to make sure that H11 and G11 differ by less than 1%.

And yet the spreadsheet the formula is in was returned to me by my boss'
boss...saying "this formula makes no sense!" Despite the fact that it does.

So....is there a cleaner way of doing the same calculation?

Dave
--
Brevity is the soul of wit.

--

Dave Peterson