Nested Multiple IF

Options
Shawn O'Banion
Shawn O'Banion ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have a formula I am trying to work out using multiple dropdown menu options that add different formula instances.  I am trying to use multiple IF statements, but I am getting an unparsable error.

Here is the formula, the dropdowns are 4 options LVL2 RBH, LVL2 OOH, LVL4 RBH, and LVL4 OOH.

Note - IF I use only the first IF statement as a formula it works, it's when I add the second IF that it creates the error.

=IF(([Tech Level]26 = "LVL2 RBH", ([Tech Days]26 * 380) + Expenses26), IF([Tech Level]26 = "LVL2 OOH", ([Tech Days]26 * 400) + Expenses26))

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!