Multiple IF Statements

klangridge103846

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!

Paul Newcome

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

Paul Newcome

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

Steven Evans

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,

klangridge103846

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

Paul Newcome

Happy to help. 👍️