Forum Academy Marketplace Showcase Pricing Features

How can I calculate formulas with parentheses?

I’m porting over an excel spreadsheet that uses formulas to calculate the total cost of something. Here’s one formula I use in excel to include a 15% tip:

=SUM(total+(total*0.2))

Is there a way to use parentheses?

Install math.js plugin. Also look at the documentation

1 Like

Im trying to do this with expressions as well, for example: When current user is This AND (This OR That) do this, is that possible?

Im trying to do this with expressions as well, for example: When current user is This AND (This OR That) do this, is that possible?

That’s a different issue to my original post. However, in that case, you’ll want to go into the Conditional tab for your element to implement those checks.

i think you didnt understand my question,

i wanna write a condition, which would express an AND logic but the OR should be a part of the 2nd argument, like putting it in parenthesis

Can’t you add the or as a different codition? See the order of the conditional logic takes precedence. The farthest it is Dow the higher priority it has.

Just break down the problem into smaller bits to be able to better Handel it

1 Like

got it tnx