Home/ Questions/Q 1779
Next
Answered
computing
  • 0
Asked: 2021-10-25T13:52:45+00:00 In:

Solved I Want To Make a Scoring System With Excel

  • 0

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?

Share

    1 Answer

    1. 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.

      • 0