Help

IF from single select option

Topic Labels: Formulas
2032 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Bab_Bit
4 - Data Explorer
4 - Data Explorer

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.

3 Replies 3

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.

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