Brackets in formula | WordPress.org

Resolved alexisoceandigital
(@alexisoceandigital)

5 years, 4 months ago

Hello,
I need to calculate the following formula:

m = [C × t/12]/[1−(1 + t/12)−n]
where -1 is in superscript

I was able to make the first part of the formula working but i’m not sure of the superscript part …

Basically right now it’s:

(fieldname1*fieldname6/12)/1-(1+fieldname6/12)

how can I use the value -n in superscript ?

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author codepeople
(@codepeople)

5 years, 4 months ago
Hello @alexisoceandigital

You are talking about the POW operation, for example, 2^3 would be POW(2,3)

In your equation, I don’t know who is superscript.

Best regards.
- This reply was modified 5 years, 4 months ago by codepeople.
Thread Starter alexisoceandigital
(@alexisoceandigital)

5 years, 4 months ago

Basically here’s the formula:

https://tinyurl.com/y2ckprmc

It’s a screenshot because the copy paste is messed up
Plugin Author codepeople
(@codepeople)

5 years, 4 months ago
Hello @alexisoceandigital

In this case, the equation would be:
```
(C*t/12)/(1-POW(1+t/12, -n))
```
Now, you only should replace the constants by the corresponding fields’ names.

Best regards.
Thread Starter alexisoceandigital
(@alexisoceandigital)

5 years, 4 months ago

Thank you for your answer the formula is working, but how can I round the result ?

I have like 10 decimals and i’d like to riund the number without decimals

Plugin Author codepeople
(@codepeople)

5 years, 4 months ago

Hello @alexisoceandigital

There are multiple alternatives for rounding the results. Please, read the following post in the plugin’s blog:

https://cff.dwbooster.com/blog/2020/09/20/rounding-numbers/

Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Brackets in formula’ is closed to new replies.

5 replies
2 participants
Last reply from: codepeople
Last activity: 5 years, 4 months ago
Status: resolved