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!

Find more posts tagged with

Accepted answers

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

All comments

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

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.