IF function

[samolorz]

Hello, I have a small question. I have a column that should change if another column has data. For example. If column "X" is equal to "X" value. So the value should be "A"

But if column "X" and column "Y" have "X" value then it must be "B"

And lastly, if column "X" and column "Y" and column "Z" have "X" value then it should be "C"

No formulas on the sheet. Everything in the app 

[peterson · Accepted solution]

Hello, in this case you should go with formula IFS and AND, example:

IFS( AND(
ISNOTBLANK([column X]),ISBLANK([column y]), ISBLANK([column z])),
"A",
AND(
ISNOTBLANK([column y]), ISBLANK([column x]), ISBLANK([column z])),
"B",
ISNOTBLANK([column z]), ISBLANK([column x]), ISBLANK([column y])),
"C"
)

Here my logic is: if is not empty or blank the column x bu the others are, return A... If is not blank the column y, but the others are, return B, etc.

This is the logic I see in it

[samolorz]

Muchas gracias It worked perfect 

[EliK]

Not a problem. Put your IF expression into the Formula bar of the column (not the initial value) You may also want to consider making this column a virtual column, since it is calculated based on other columns.