nested formulas in excel using iserror and if
 

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

nested formulas in excel using iserror and if
 

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

Hope this helps,

Hutch

"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

nested formulas in excel using iserror and if
 

Thanks Tom!

Just discovered that myself.

Amazing what that silly little decimal point will do. Hahaha


"Tom Hutchins" wrote:

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

Hope this helps,

Hutch

"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