Solved I want to make a scoring system with excel

March 9, 2012 at 13:09:47
Specs: Microsoft Windows 7
Anybody can help me?
I want to make a scoring system depending on the data I enter: fx.

If enter male in A1 Excel will give a score of 2 in A2
If enter female in A1 Excel will automatically give a score of 4 in A2
If enter age < 30 score of 0
If enter age 30-50 score of 2
If enter age >50 score of 4
Ans so on, so I have a total score in the end.

How do I do this?


See More: I want to make a scoring system with excel

Report •

#1
March 9, 2012 at 17:34:45
In A2:

=IF(A1="male",2,IF(A1="female",4,"Error"))

In B2:

=IF(B1<30,0,IF(B1<=50,2,IF(B1>50,4,"Error")))

In A4:

=SUM(A2:J2)

Or whatever cells you want to put things.


Report •

#2
March 9, 2012 at 18:31:21
✔ Best Answer
If male and female are your only choices, use a Data Validation Drop Down list that only contains those 2 choices. That way you don't need to worry about any errors.

Your formula can then be very simple:

=IF(A1="male", 2, 4)

You can also use a Drop Down for your ages and simplify the other formula also:

=IF(B1<30, 0, IF(B1< 51, 2, 4))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question