Title: Roundup
Last modified: August 22, 2016

---

# Roundup

 *  Resolved [wombat65](https://wordpress.org/support/users/wombat65/)
 * (@wombat65)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/roundup/)
 * Great plug-in 🙂
    Just one issue with roundup. When I use ROUNDUP(x,-5) it works
   great until the input is above 1,000,000 and a multiple of 100,000. For example
   jazzy rounds-up 1,100,000 to 1,200,000 (I get the same result in your test page
   [http://mundoacustico.com/sandbox/wp1/?p=89](http://mundoacustico.com/sandbox/wp1/?p=89))
   However, Excel leaves it at 1,100,000 with the same formula.
 * Is there any workaround?
 * [https://wordpress.org/plugins/jazzy-forms/](https://wordpress.org/plugins/jazzy-forms/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [wombat65](https://wordpress.org/support/users/wombat65/)
 * (@wombat65)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/roundup/#post-5707230)
 * For those with the same issue, this worked for me:
    ROUNDUP(x/100000,0)*100000

Viewing 1 replies (of 1 total)

The topic ‘Roundup’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/jazzy-forms_dac291.svg)
 * [Jazzy Forms](https://wordpress.org/plugins/jazzy-forms/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/jazzy-forms/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/jazzy-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/jazzy-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/jazzy-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/jazzy-forms/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [wombat65](https://wordpress.org/support/users/wombat65/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/roundup/#post-5707230)
 * Status: resolved