nested formulas in excel using iserror and if

  • Thread starter Thread starter Vicki
  • Start date Start date
V

Vicki

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
 
The value of 20% is 0.2 not 20. Change ABS(20) to ABS(.2)

Hope this helps,

Hutch
 
Thanks Tom!

Just discovered that myself.

Amazing what that silly little decimal point will do. Hahaha
 
Back
Top