Hi,
i want generate a new colum which computes three possible values (A,D or H)
A = Score2>Score1
D = Score2==Score1
H = Score1>Score2
Score1 Score2
2 4
2 2
5 1
Result
A
D
H
Through the following syntax i can generate two values, but how can i generate the three possible options (A,D,H)?
if(Score1>Score2, "H", "A or D")
Thanks and sorry my ignorance
You can write nested IF.
If (Score1>Score2, "H", if(Score1<Score2,"A","D"))