Formula to round up to nearest .25 - InfoPath Dev Sign in | Join | Help in General InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » General » Formula to round up to nearest .25 Formula to round up to nearest .25 Last post 07-16-2010 02:55 AM by grichard21. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 07-16-2010 01:37 AM grichard21 Joined on 07-16-2010 Posts 2 Formula to round up to nearest .25 Reply Contact Hi, I have a formula in excel which I use to round up to the nearest .25, does anyone know how I can do this in Infopath. This is the formula I use in Excel =CEILING(((H13)+((H13)*14.5/100)), 0.25) Cheers 07-16-2010 02:39 AM In reply to Jimmy Joined on 07-03-2008 Posts 2,595 Re: Formula to round up to nearest .25 Mark as Not AnswerMark as Answer... Reply Contact ceiling(value * 4) div 4 should do the trick. Jimmy Rishe / Software Developer / Microsoft MVPQdabra Software 07-16-2010 02:55 AM In reply to grichard21 Joined on 07-16-2010 Posts 2 Re: Formula to round up to nearest .25 Mark as Not AnswerMark as Answer... Reply Contact Cheers, this works great Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Hi,
I have a formula in excel which I use to round up to the nearest .25, does anyone know how I can do this in Infopath.
This is the formula I use in Excel
=CEILING(((H13)+((H13)*14.5/100)), 0.25)
Cheers
ceiling(value * 4) div 4
should do the trick.
Cheers,
this works great