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?

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.

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.

Ask Your Question

Weekly Poll