Multiple IF values

[unclejemima]

I've got a table called trandata, and a column called Send.  So Trandata[Send]

In Trandata[Send] can be either a 1, 2, 3, 4 or a 5.

Send = 1 = Journal

Send =2 = Bill

Send =3 = Invoice

Send =4 = A/R payment

Send =5 = A/P payment

With that, I was trying to make a or(if) statement...but I can only do 2 expressions. 

I want to make a calc column that if Trandata[Send] = 1, "Journal", if Trandata[Send]=2, "Bill", and so on.

Can someone tell me how I would do this?

[unclejemima]

Perfect thank you!

[RMDNA · Accepted solution]

@unclejemima,

When thinking about using multiple IF( ) statements, it's usually easier to use SWITCH( ).

In your case, you'd use:

Category = SWITCH(Trandata[Send], 1,"Journal",2,"Bill",3,"Invoice",4,"A/R payment",5,"A/P payment")

which will give you: