iserror and ifs nested formulas
=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)20%,((C30-$G30)/$G30),"
"))
Your formula had greater than, but not less than.
20 is different from 20% (by a factor of 100).
You don't need the ABS function.
--
David Biddulph
"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
|