Data classification with 3 values through Turbo Grep

User222697

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

varunm1

Hello @User222697

You can write nested IF.

If (Score1>Score2, "H", if(Score1<Score2,"A","D"))