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

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

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

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

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

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