nested formulas in excel using iserror and if

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
 
T

Tom Hutchins

The value of 20% is 0.2 not 20. Change ABS(20) to ABS(.2)

Hope this helps,

Hutch
 
V

Vicki

Thanks Tom!

Just discovered that myself.

Amazing what that silly little decimal point will do. Hahaha
 

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

Similar Threads

iserror and ifs nested formulas 3
Countif and Sumif with refrence value a Cell on another Sheet in theWorkbook 3
Help with adding a bit to an existing If Statement 4
Need more than 7 formulas in one cell 2
Run code on "IF" formula result change 3
Need help with formula 3
Select Case problem when hitting the Delete key 2
Help with nested if/or statements 8

Top