IF from single select option

Hi,

I can’t get the formula to work. Can we do condition formula on Single select option?

Example;
Single select option
Category
A
B

I’ve tried, IF(Category=A / IF(Category=‘A’ & IF(Category=“A” but none work. Please help.

What I need is; IF Category is A, “Yes”, Else “No”

I have no problem for digits, but stuck for text.
Thank you.

+25

HI @Bab_Bit and welcome to the community!

Try

IF(Category=“A”, “Yes”, “No”)

ps: be sure to check you didn’t add a space after your options in your select field!

Jan - Databaser

HI @Bab_Bit and welcome to the community!

Try

IF(Category=“A”, “Yes”, “No”)

ps: be sure to check you didn’t add a space after your options in your select field!

Hi, thank you.

It still doesn’t work. It should be straightforward, not sure why still doesn’t work.

+2

HI @Bab_Bit and welcome to the community!

Try

IF(Category=“A”, “Yes”, “No”)

ps: be sure to check you didn’t add a space after your options in your select field!

IF(Category="A", "Yes", "No") works fine for me.

Sign up