Link to home
Create AccountLog in
Avatar of jhall0528
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!  
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jhall0528
jhall0528

ASKER

well, while that sounds simple...I just get a bunch of ####### in my cell. Specifically the E column has the correct answers.......so I tried a formula in the e column =IF(E90="c",1,0)
The correct answer is C in E90
any ideas????
May I see a sample workbook?

Sid
Avatar of barry houdini
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
Thanks a bunch!!!!