Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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. |