Help with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could try testing Counta for 0,

=IF(COUNTA(E30:E82), TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"),
"")
 
Rewrite your formula to the following:

=if(counta(e30:e82)=0,"",TEXT(COUNTIF(E30:E82,"Yes")/COUNTA(E30:E82),"#,##0%"))
 
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...
 
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
(e-mail address removed)
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...
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculation based on meeting two criteria 2
Blanks ("") by Formula 2
Excel Need Countifs Formula Help 0
Excel formula, sum the value cell and if empty cell left blank 0
Desperately need help with a formula 2
Need formula help! Removing a neg# & #DIV/0! 4
Help with another formula, please 3
Nested If not returning correct values 5

Back
Top