Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested formulas in excel using iserror and if | Excel Discussion (Misc queries) | |||
Remove #NUM! ISERROR when using array formulas | New Users to Excel | |||
iserror and conditional formulas | Excel Discussion (Misc queries) | |||
nested IF(ISERROR()) statement | Excel Discussion (Misc queries) | |||
Iserror nested within a conditional vlookup | Excel Worksheet Functions |