IF, OR and AND, which one should I use

I have a code and I wonder if I can actually get this to work.

Can a code be written where there are three options, with three different answers,


if X=1,Then A, else C OR if Y=1, Then B, else C

I thought I should write it like below, but it doesn’t seem to work.

OR(if(X=1,ThenA),if(Y=1,Then B),Else C)

Hi @gkpbydesign ,

If I understand right, C is the default value for both conditions ? So this should work :

if(X = 1, A, if(Y = 1, B, C))

Basically, you need to nest another condition after the first else : if X = 1 then A, else if Y = 1 then B, else C.