Converting letters to numbers for functions

May 2, 2009 at 13:06:36
Specs: Windows XP
I have a column that will have either a 'P' for pass or an 'F' for fail. I want to add the number of P's and then divide by the total number of P's and F's to get an average that passed. How do I write the function? Thanks!

See More: Converting letters to numbers for functions

Report •


#1
May 3, 2009 at 00:29:00
Katysad, use variables for 'P' and 'F'. Increment each as another's detected and perform the average when done. Don't forget to clear the variables before the next run. BTDT.
HTH.
Ed in Texas.

Report •
Related Solutions


Ask Question