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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History