Nested Multiple IF

Shawn O'Banion

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))

Chris McKay

Hi Shaun,

You've got a double bracket at the beginning of your first IF statement. Remove that and you should be good.