iserror and ifs nested formulas

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
 
B

Bob Phillips

Try

=IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G30>0.2,(C30-$G30)/$G30,"
"))
 
D

David Biddulph

=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.
 
S

Steve

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top