Nested Multiple IF
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))
Help Article Resources
Check out the Formula Handbook template!