twogilvy - yes and no entries

J

JY

I wasn't sure if my response went through or not, so
excuse me if this is a duplicate. Tom, I appreciate your
response. I tried to enter the formulas that you gave me
and they did not work. The first formula that you gave me
continued to show a 0.0% in the cell after I entered yes
and no information in the nine cells. The second formula
left a #DIV/0 in the cell after I entered yes and no
information in the nine cells. Can you tell me what I may
be doing wrong. If it would help to see the worksheet, I
would be happy to send it to you via e-mail if you would
leave me your e-mail address. My e-mail is
[email protected]. Thanks again for the help.
 
N

Norman Jones

Hi JY,

Tom's first formula worked fine for me as did his second formala, after
amending a small typo: change the last "yes" to "no"

I was able to get your results if I entered my yes/no data in cells outside
of the range $B$3:$B$11 specified in Tom's formulae.

Incidentally, you make it inordinately hard to help you by starting a new
thread.
 
Top