Nested IF to populate Cell

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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.