What is the formula for: the letter x = 3.7 for a possilbe grand total of
100% once all values are calculate

Please explain in(quite) a bit more detail what you are trying to do

--
Kind regards,

Niek Otten

"Grass" wrote in message ...
What is the formula for: the letter x = 3.7 for a possilbe grand total of
100% once all values are calculate

I have 12 people I need to evaluate/audit. I have 27 questions they must
answer and they either get the answer correct or incorrect. I have two
columns with headings "correct" and "incorrect". I need to type an "X" in
the cell if they got the answer correct or incorrect. Each "X" needs to
equal 3.7% for a possible total of 100% from the 27 questions. Does this make
sense? I know it's somewhat elementary but I will also need to calculate
how many questions they answered correctly or incorrectly. Thanks

"Niek Otten" wrote:

Please explain in(quite) a bit more detail what you are trying to do

--
Kind regards,

Niek Otten

"Grass" wrote in message ...
What is the formula for: the letter x = 3.7 for a possilbe grand total of
100% once all values are calculate

Suppose your correct column is B with potential "x"s in B2:B28 you could
use this formula

=COUNTIF(B2:B28,"x")/ROWS(B2:B28)

format as percentage


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522728

Can you spell out how I would do this? I'm not real savy on excel. Thanks

"daddylonglegs" wrote:


Suppose your correct column is B with potential "x"s in B2:B28 you could
use this formula

=COUNTIF(B2:B28,"x")/ROWS(B2:B28)

format as percentage


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522728

You just need to put that formula

=COUNTIF(B2:B28,"x")/ROWS(B2:B28)

into a cell on your worksheet. Any cell except one of those referenced
in the formula. Then you should see a numeric result, hopefully less
than 1. If you then use the Format menu and select

Cells Number Percentage and specify the number of decimal places
you wish to see. Now it should show the corect percentage


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522728