InfoPath Dev

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 

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

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

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

(ceiling(field * 100)/100)

What would be the proper way to enter?

 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

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."

 Worked! Thanks.