Multiple IF Statements
I am using the following formula which is correct and working as expected
=(IF([Panel Type]@row = "P", ([Total Cost for Mediation]@row * [Panel Fee %]@row)))
However when I try to add in another IF it stops working
=(IF([Panel Type]@row = "P", [Total Cost for Mediation]@row * [Panel Fee %]@row)), (IF([Panel Type]@row = "C", [Total Cost for Mediation]@row * [Chambers Fee %]@row))
I actually need to add a further IF but want to work out where I am going wrong first!
Best Answer

You are using too many parenthesis. Try this...
=IF([Panel Type]@row = "P", [Total Cost for Mediation]@row * [Panel Fee %]@row, IF([Panel Type]@row = "C", [Total Cost for Mediation]@row * [Chambers Fee %]@row))
Answers

You are using too many parenthesis. Try this...
=IF([Panel Type]@row = "P", [Total Cost for Mediation]@row * [Panel Fee %]@row, IF([Panel Type]@row = "C", [Total Cost for Mediation]@row * [Chambers Fee %]@row))

Hey There,
I'm assuming you wanted to add the other IF statement as the else value  it looks as if you have too many brackets / wrong placement. If you get stuck w/ formulas, always good to layout the structure as below with indenting and then you can more easily see where the syntax errors are.
"
=
( <remove
IF(
[Panel Type]@row = "P",
[Total Cost for Mediation]@row * [Panel Fee %]@row
) <remove
) <remove
,
( <remove
IF(
[Panel Type]@row = "C",
[Total Cost for Mediation]@row * [Chambers Fee %]@row
)
)
"
n/b  I would also suggest adding an else to the second IF statement as a best practice, if case your panel type is anything other than P or C.
Regards,

Thank you both for your help! I can be a bit bracket happy! :)

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!