Thread: iserror and ifs nested formulas
View Single Post
  #5  
Old June 4th, 2010, 09:34 PM posted to microsoft.public.excel.worksheet.functions
Vicki
external usenet poster
  
Posts: 145
Default iserror and ifs nested formulas
Bob,

Thank you so much for your input. This formula worked GREAT!

"Bob Phillips" wrote:

Try

=IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G300.2,(C30-$G30)/$G30,"
"))

--

HTH

Bob

"Vicki" wrote in message
...
Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30),"
"))

Thanks



.