Help with a formula

A

Angeline

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
 
J

JMB

You could try testing Counta for 0,

=IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"),
"")
 
G

galimi

Rewrite your formula to the following:

=if(counta(e30:e82)=0,"",TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"))
 
A

Angeline

thank you very much!

JMB said:
You could try testing Counta for 0,

=IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"),
"")


Angeline said:
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
Click to expand...
Click to expand...
 
A

Angeline

Thanks a million, that's just what I'll do.
Cheers

galimi said:
Rewrite your formula to the following:

=if(counta(e30:e82)=0,"",TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"))
--
http://HelpExcel.com
[email protected]
516-984-0252


Angeline said:
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
Click to expand...
Click to expand...
 
J

JMB

You're welcome. Thanks for the feedback.

Angeline said:
thank you very much!

JMB said:
You could try testing Counta for 0,

=IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"),
"")


Angeline said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top