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

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