IF Conditional Formatting

[magsbiel]

Hi,

I have two columns in my data:

Item   Category

A        Apple

B        Apple

C        Lemon

D        Orange

E        Apple

I am trying to replace "Apple" for "B" with "Banana" and "Apple" for "E" with "Banana" as well. I tried IF statements, switch, nothing works. Any idea how to do it?

[afv2688 · Accepted solution]

Hello @magsbiel ,

Does this work for you?

IIF([2] = 'Apple' AND [1] IN ('B','E'), 'Banana', [2])

Regards

[magsbiel]

It worked. Thank you so much!