formula and value help
 

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

formula and value help
 

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

formula and value help
 

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

formula and value help
 

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

formula and value help
 

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

formula and value help
 

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

formula and value help
 

This was very helpful daddylonglegs. You solved my problem. Thank you so
much!!!!!!!!!!!!! :)

"daddylonglegs" wrote:


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

formula and value help
 

So now I have this guy in my office that says my excel spread sheet is very
nice but,

"in order to be able to store the historical results in order to enable
trend-tracking, it's going to be a massive spreadsheet. I'm working with a
guy I know who is a database specialist to create a specific auditing
database that will have an input form which lets you put all the information
in and stores all the results, then lets you create specific reports that are
targeted for our purposes"

Can excell do this too? I'm sure it can if I had the know how. Does anyone
want to walk me through this? I can't wait two weeks.

"Grass" wrote:

This was very helpful daddylonglegs. You solved my problem. Thank you so
much!!!!!!!!!!!!! :)

"daddylonglegs" wrote:


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