iserror and ifs nested formulas
What numbers are likely to be in cells C30 and G30
What should it be 20% of
Why use ABS
What errors do you anticipate
Regards
Steve
"Vicki" wrote:
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
|