If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
iserror and ifs nested formulas
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 |
#2
|
|||
|
|||
iserror and ifs nested formulas
Try
=IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G300.2,(C30-$G30)/$G30," ")) -- HTH Bob "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
iserror and ifs nested formulas
Bob,
Thank you so much for your input. This formula worked GREAT! "Bob Phillips" wrote: Try =IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G300.2,(C30-$G30)/$G30," ")) -- HTH Bob "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 . |
Thread Tools | |
Display Modes | |
|
|