=IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID")
Pretty much!
Biff
"Dave F" wrote in message
...
I think the real answer here is "there's no way to make it more clearer
than
it is"...
Dave
--
Brevity is the soul of wit.
"T. Valko" wrote:
=IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID")
Maybe this:
=IF(ABS(1-(H11/G11))<0.01,"VALID","INVALID")
You might want to make sure you don't get a #DIV/0! error:
=IF(G11=0,"",IF(ABS(1-(H11/G11))<0.01,"VALID","INVALID"))
Biff
"Dave F" wrote in message
...
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.
|