Thread: =IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID")
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default =IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID")
Sorry I copied it incorrectly below. Should be
=IF(ABS(1-(H11/G11))<ABS(0.01)),"VALID","INVALID")

Dave
--
Brevity is the soul of wit.


"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.
Reply With QuoteReply With Quote