Hide/Show Zeros when using a formula

[becky04]

Hi, I want to have a formula that converts a Yes answer to a percentage - let's say 25% for now.

=IF(F6="Yes",0.25,0)+IF(G6="Yes",0.25,0)+IF(H6="Yes",0.25,0)+IF(I6="Yes",0.25,0)

This works for me - it totals up to 100% if all yes across 4 cells. I want to hide zero's where the cells haven't been populated yet with a yes or a no. BUT if all four cells are populated with a no or one cell has a no and the rest are empty, then I want the zero to be displayed - 0%.

I can only manage to figure out how to hide ALL zero's or have them all show.

[shg]

=IF(SUM(COUNTIF(F6:I6, {"yes","no"})), SUMPRODUCT((F6:I6 = "yes")*0.25), "")

[becky04]

That works awesome, thank you!

Different question - is there a way to format the text so all users are entering the text Yes or No the same. So we dont get variations; YES Yes yes YeS etc?

[shg]

Data Validation > Data Validation, Settings tab, Allow: List, Source: Yes,No

[becky04]

I appreciate your quick response and help, thank you!

[shg]

You're welcome.