Thread
:
Help with a formula
View Single Post
#
3
Posted to microsoft.public.excel.misc
galimi
external usenet poster
Posts: 210
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
Reply With Quote
galimi
View Public Profile
Find all posts by galimi