=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.