Title: Brackets in formula
Last modified: December 9, 2020

---

# Brackets in formula

 *  Resolved [alexisoceandigital](https://wordpress.org/support/users/alexisoceandigital/)
 * (@alexisoceandigital)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/)
 * 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](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13765684)
 * Hello [@alexisoceandigital](https://wordpress.org/support/users/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](https://wordpress.org/support/users/codepeople/).
 *  Thread Starter [alexisoceandigital](https://wordpress.org/support/users/alexisoceandigital/)
 * (@alexisoceandigital)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13765748)
 * Basically here’s the formula:
 * [https://tinyurl.com/y2ckprmc](https://tinyurl.com/y2ckprmc)
 * It’s a screenshot because the copy paste is messed up
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13765830)
 * Hello [@alexisoceandigital](https://wordpress.org/support/users/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](https://wordpress.org/support/users/alexisoceandigital/)
 * (@alexisoceandigital)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13770905)
 * 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](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13770963)
 * Hello [@alexisoceandigital](https://wordpress.org/support/users/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/](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.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/brackets-in-formula/#post-13770963)
 * Status: resolved