Nested IF to populate Cell

Meagan80

Hi,

I have a nested If formula I am having trouble with,

=IF(Category@row = "Drink", "Lemonade, Tea, Water, Soft Drink", =IF(Category@row = "Toping", "Pepperoni,Steak,Chicken", IF(Category@row = "Fries", "Cheese, Chili")))

I have a drop in the Category column. If I choose the "Drink" option is is working fine, but if I choose "Toping" or "Fries" I am getting #Invalid Operation error. I made sure the spelling and format matches.

Heather Duff

Hi @Meagan80 ,

It looks like you've got an extra equal sign right before your second IF. Try removing that and see if it fixes it.

Best,

Heather

Heather Duff

Hi @Meagan80 ,

It looks like you've got an extra equal sign right before your second IF. Try removing that and see if it fixes it.

Best,

Heather