=IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID")
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.
|