[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

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!  
0
jhall0528
Asked:
jhall0528
  • 2
  • 2
1 Solution
 
SiddharthRoutCommented:
With your above example, you can have a simple formula.

=If(A1="c",1,0)

Sid
0
 
jhall0528Author Commented:
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????
0
 
SiddharthRoutCommented:
May I see a sample workbook?

Sid
0
 
barry houdiniCommented:
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
0
 
jhall0528Author Commented:
Thanks a bunch!!!!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now