A couple of possibilities

What do you see - do you see the formula you just entered?

if so, is the very first character of the formula and equal sign as shown

if it is, is the cell formatted as text? If so, format the cell as general,
select the cell, hit F2, then enter

If you still see the formula, go into tools=Options and select the View
tab, make sure Formulas is unchecked at the bottom area (Windows Options).

do Ctrl+Alt+F9 - does it calculate?

If so, then perhaps you have calculation set to Manual
Tools=Options=Calculation tab and click on Automatic

Other than that, it should calculate when you enter it.

However, you have to change the formulas offered so they point to the actual
location of your data (where the Y's and N's are). Mine pointed to column A
and Andy's pointed to Cells C1 to C100.



Regards,
Tom Ogilvy



"Kim" wrote in message
...
OK, i have put the formula in that you gave me, changing
the row and column numbers accordingly, now, how do i get
the formula to actually calculate? i am not very familiar
with using excel except for data entry.

Thanks again,
Kim
-----Original Message-----
I am trying to make a column with the cell showing a "Y"
for yes or a "N" for no. is there a formula that will
tell me what percentage is yes versus no? i have read
through the help section on this issue and still can't
figure this out. My boss wants me to get this resolved
and i am at the end of my rope. Please help.

Thanks,
Kim
.