{"id":5707129,"date":"2015-01-24T04:43:40","date_gmt":"2015-01-24T04:43:40","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/roundup\/"},"modified":"2016-08-22T15:45:22","modified_gmt":"2016-08-22T15:45:22","slug":"roundup","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/roundup\/","title":{"rendered":"Roundup"},"content":{"rendered":"<p>Great plug-in \ud83d\ude42<br \/>\nJust 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.<br \/>\nFor 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)<br \/>\nHowever, Excel leaves it at 1,100,000 with the same formula.<\/p>\n<p>Is there any workaround?<\/p>\n<p>https:\/\/wordpress.org\/plugins\/jazzy-forms\/<\/p>\n","protected":false},"template":"","class_list":["post-5707129","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5707129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5707129\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5707129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}