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.

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!

1 Like

Hi, thank you.

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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.