I have a spread sheet where a question is answered with a yes or no how
do i convert that into a percentage for the entire row?

a1 complete?
a2 yes
a3 no
a4 no
a5 no
a6 percent complete
a7 25%

does this make sense?