Formula help with if not equal.

Hello,

I am trying to get an output of Supplier Segmentation as 3 Categories, “Preferred”, “Strategic” and “Non Preferred”. Right now, I have 5 different categories as shown in the screen shot.

My formula is

If [Supplier Segmentation] != "Preferred" or "Strategic" then "Non Preferred" Else [Supplier Segmentation] Endif

My out is

What am I doing wrong with that formula? My output should be 3 Categories, “Preferred”, “Strategic” and “Non Preferred”.

Thanks,

Adam

Data Investigation

Accepted answers

Luke_C

Sorry try changing the or to an AND

All comments

Luke_C

Hi @Adam_B

Try this:

If [Supplier Segmentation] != "Preferred" or [Supplier Segmentation] != "Strategic" then "Non Preferred" Else [Supplier Segmentation] Endif

Adam_B

@Luke_C Nope, now I just get Non Preferred

Luke_C

Sorry try changing the or to an AND

Adam_B

@Luke_C That worked, thank you.

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335