# 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 A2If enter female in A1 Excel will automatically give a score of 4 in A2If enter age < 30 score of 0 If enter age 30-50 score of 2If 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

#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
 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