G
Guest
What is the formula for: the letter x = 3.7 for a possilbe grand total of
100% once all values are calculate
100% once all values are calculate
N
Niek Otten
Please explain in(quite) a bit more detail what you are trying to do
G
Guest
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
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
D
daddylonglegs
Suppose your correct column is B with potential "x"s in B2:B28 you coul
use this formula
=COUNTIF(B2:B28,"x")/ROWS(B2:B28)
format as percentag
use this formula
=COUNTIF(B2:B28,"x")/ROWS(B2:B28)
format as percentag
G
Guest
Can you spell out how I would do this? I'm not real savy on excel. Thanks
D
daddylonglegs
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 reference
in the formula. Then you should see a numeric result, hopefully les
than 1. If you then use the Format menu and select
Cells > Number > Percentage and specify the number of decimal place
you wish to see. Now it should show the corect percentag
=COUNTIF(B2:B28,"x")/ROWS(B2:B28)
into a cell on your worksheet. Any cell except one of those reference
in the formula. Then you should see a numeric result, hopefully les
than 1. If you then use the Format menu and select
Cells > Number > Percentage and specify the number of decimal place
you wish to see. Now it should show the corect percentag
G
Guest
This was very helpful daddylonglegs. You solved my problem. Thank you so
much!!!!!!!!!!!!!
much!!!!!!!!!!!!!
G
Guest
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.
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.