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 |
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 |
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 |
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 |
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 . |
All times are GMT +1. The time now is 01:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com