jhall0528

asked on

# Excel help (if then formulas)

I need Microsoft excel help, I'm trying to design a spreadsheet to grade my students tests.

There are 20 answers. To make it easier, I need a function to test If question 1 = c than 1 pt is given otherwise if question 1 = b or a, 0 pt is given. The answers will vary, so I need a function that will suffice all 20 questions. Thanks!

There are 20 answers. To make it easier, I need a function to test If question 1 = c than 1 pt is given otherwise if question 1 = b or a, 0 pt is given. The answers will vary, so I need a function that will suffice all 20 questions. Thanks!

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

May I see a sample workbook?

Sid

Sid

Try this for all 20 questions

If you list the question answers somewhere on the worksheet, e.g. in Z2:Z21 then assuming that the student answers are entered in E2:E21 just use this formula in F2 copied down

=(E2=Z2)+0

see attached

regards, barry

26818464.xls

If you list the question answers somewhere on the worksheet, e.g. in Z2:Z21 then assuming that the student answers are entered in E2:E21 just use this formula in F2 copied down

=(E2=Z2)+0

see attached

regards, barry

26818464.xls

ASKER

Thanks a bunch!!!!

ASKER

The correct answer is C in E90

any ideas????