Solved

Excel help (if then formulas)

Posted on 2011-02-13
5
357 Views
Last Modified: 2012-05-11
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
Comment
Question by:jhall0528
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 250 total points
ID: 34883620
With your above example, you can have a simple formula.

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

Sid
0
 

Author Comment

by:jhall0528
ID: 34883657
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34883669
May I see a sample workbook?

Sid
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 34883792
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
 

Author Closing Comment

by:jhall0528
ID: 34883848
Thanks a bunch!!!!
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

736 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question