How to include Paranthesis in formula.

dsmartsheetuser

I am using an IF formula in a Total column

Column A

A) Option 1

B) Option 2

Total Column

= IF ([Column A]@row = "A) Option 1" , "3", IF([Column A]@row = "B) Option 2" , "5"))

I am getting error, as ) is prematurely closing out the computation.

Any help is much appreciated.

Thank you,

Deepthi

Find more posts tagged with

Formulas

Accepted answers

All comments

Zachary Hall

You need to put a final "ELSE" clause in that nested IF( statement. Something like:

= IF ([Column A]@row = "A) Option 1" , "3", IF([Column A]@row = "B) Option 2" , "5", FALSE))

Replace that FALSE with whatever you would like to appear if it is not either of those things.

dsmartsheetuser

Hi Zachary,

Thank you for your response. My issue is with: = IF ([Column A]@row = "A) Option 1" , "3", IF([Column A]@row = "B) Option 2" , "5"))

If I use: = IF ([Column A]@row = "A. Option 1" , "3", IF([Column A]@row = "B. Option 2" , "5")) - I do Not get error. However, if I use "A)" I am getting error with ")".

Thank you,

Deepthi

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.