Title: Rounddown formula
Last modified: August 22, 2016

---

# Rounddown formula

 *  Resolved [WillBigGun](https://wordpress.org/support/users/willbiggun/)
 * (@willbiggun)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/)
 * Hi there,
 * Is there a way to round down like an excel formula similar to =ROUNDDOWN(fieldname1,2)
 * Regards
 * [https://wordpress.org/plugins/calculated-fields-form/](https://wordpress.org/plugins/calculated-fields-form/)

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644045)
 * Hi,
 * Our plugin includes the operation ROUND, FLOOR, and PREC, the most similar operation
   to the ROUNDDOWN is PREC
 * PREC(fieldname1,2)
 * but the last two digits can be rounded down or up, so, my recommendation is to
   use a combined operation like follow:
 * PREC(FLOOR(fieldname1*100)/100,2)
 * Best regards.
 *  Thread Starter [WillBigGun](https://wordpress.org/support/users/willbiggun/)
 * (@willbiggun)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644053)
 * That’s awesome. How could we round to the nearest 4 decimals? Like making 0.46634885
   = 0.4663
 * Regards
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644057)
 * Hi,
 * You simply should follow the same process, use the operation:
 * PREC(fieldname1,4)
 * or to obtain exactly the same result of ROUNDDOWN:
 * PREC(FLOOR(fieldname1*10000)/10000,4)
 * Best regards.
 *  Thread Starter [WillBigGun](https://wordpress.org/support/users/willbiggun/)
 * (@willbiggun)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644084)
 * Hi there,
 * Is there a way to let the user see the submitted data they have input on another
   screen? Like a quote summary screen?
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644091)
 * Hi,
 * Yes, that’s possible. There are two way to do that; displaying the summary directly
   in the form, before the submission, or displaying the summary in the thank you
   page (the option with the thank you page is only available in the paid versions
   of the plugin).
 * To display the summary in the form you simply should insert a summary field in
   the form, and select the other fields to include in the summary.
 * To display the summary in the thank you page is very similar but you should use
   a shortcode.
 * Please, check the following questions in the FAQ of the plugin ([https://wordpress.org/plugins/calculated-fields-form/faq/](https://wordpress.org/plugins/calculated-fields-form/faq/)):
 * Q: Could be displayed a summary of submitted fields in the thank you page?
 * Q: Could you show only a subset of submitted fields in the summary inserted in
   the thank you page?
 * Q: Is possible formatting the thank you page?
 * Best regards.
 *  Thread Starter [WillBigGun](https://wordpress.org/support/users/willbiggun/)
 * (@willbiggun)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644104)
 * Great I bought it. I want to have some calculated fields be hidden on the summary
   thank you page. Hoe do I do this?
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/rounddown-formula/#post-5644110)
 * Hi,
 * In this case you should select only the fields that will be included in the summary,
   through the “fields” attribute of the shortcode inserted in the thank you page.
   Please, read the answer to the question:
 * Q: Could you show only a subset of submitted fields in the summary inserted in
   the thank you page?
 * in the FAQ page of the plugin.
 * Best regards.

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

The topic ‘Rounddown 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/)

## Tags

 * ["round](https://wordpress.org/support/topic-tag/round/)
 * [Calculated](https://wordpress.org/support/topic-tag/calculated/)

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