So this is what i am using:
Whenever the denominator is Zero, it shows this error. Can someone please help me show a zero, instead of this error?PHP Code:
=COUNTIF((E32:E39),"Yes")/E$30
So this is what i am using:
Whenever the denominator is Zero, it shows this error. Can someone please help me show a zero, instead of this error?PHP Code:
=COUNTIF((E32:E39),"Yes")/E$30
Last edited by bholabhala; 05-18-2011 at 09:59 AM.
With Excel 2003 or 2007:
=IF(E$30=0,0,COUNTIF(E32:E39,"Yes")/E$30)
With Excel 2007:
=IFERROR(COUNTIF(E32:E39,"Yes")/E$30,0)
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
What's in e2:e39 and what result are you expecting?
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks