General

Re: Formula to Round Up to Nearest Hundreth

daniel.gruesso — Tue, 23 Mar 2010 18:39:15 GMT

Worked! Thanks.

Re: Formula to Round Up to Nearest Hundreth

Jimmy — Tue, 23 Mar 2010 14:27:57 GMT

You are saying you want to round up to the nearest hundredth, but what you are describing is rounding up to the nearest hundred [no th] so you should be using the second formula I gave you.

You need to type div not /, and you need to add a reference to the field (use the Insert field or group... button), not type the word "field."

Re: Formula to Round Up to Nearest Hundreth

daniel.gruesso — Tue, 23 Mar 2010 14:21:12 GMT

Jimmy,

I am unsure your formula will help.

What I'm trying to achieve is to round UP to the nearest hundreth, for example, if users enters the value 458, the output would be 500, etc.

Thanks

Re: Formula to Round Up to Nearest Hundreth

daniel.gruesso — Tue, 23 Mar 2010 13:54:06 GMT

Jimmy, when I enter as follows i receive an error:

(ceiling(field * 100)/100)

What would be the proper way to enter?

Re: Formula to Round Up to Nearest Hundreth

Jimmy — Tue, 23 Mar 2010 02:28:39 GMT

Round up to the nearest hundredth -> ceiling(field * 100) div 100

Round up to the nearest hundred -> ceiling(field div 100) * 100

Formula to Round Up to Nearest Hundreth

daniel.gruesso — Mon, 22 Mar 2010 21:16:08 GMT

Hello all,

I have an excel form which I am exporting to infopath.

One of the fields round UP the value to the nearest hundredth - for example 348 becomes 400.

Does anyone know how to accomplish this in infopath?

Thanks