Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
Hi there,
When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
You could try testing Counta for 0,
=IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"), "") "Angeline" wrote: Hi there, When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
Rewrite your formula to the following:
=if(counta(e30:e82)=0,"",TEXT(COUNTIF(E30:E82,"Yes ")/COUNTA(E30:E82),"#,##0%")) -- http://HelpExcel.com 516-984-0252 "Angeline" wrote: Hi there, When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
thank you very much!
"JMB" wrote: You could try testing Counta for 0, =IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"), "") "Angeline" wrote: Hi there, When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
Thanks a million, that's just what I'll do.
Cheers "galimi" wrote: Rewrite your formula to the following: =if(counta(e30:e82)=0,"",TEXT(COUNTIF(E30:E82,"Yes ")/COUNTA(E30:E82),"#,##0%")) -- http://HelpExcel.com 516-984-0252 "Angeline" wrote: Hi there, When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
You're welcome. Thanks for the feedback.
"Angeline" wrote: thank you very much! "JMB" wrote: You could try testing Counta for 0, =IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"), "") "Angeline" wrote: Hi there, When a formula returns the #DIV/0! value, I would like to add something to the formula so that the value returns to "" or blank. My current formula is: =TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"). I have used the IF(ISERROR([formula]),"",[formula])) but just not sure if I'm getting the syntax right or putting the comas where they are suppose to be or if it is the right thing to do in the first place. Hope someone can help. Cheers, Angeline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |