How to change a decimal to whole number

Question

I have a number field labeled QTY. I have another field labeled Final totals that looks at the QTY field and divides by 2. But if its a decimal i need it to round up to a whole number.

For example: if QTY=7 the Finals Totals: 3.5. It should be 4 for the Final Totals.

Is this possible with a formula?

zvibock · Answer

Just use the Round() function on the result

eudondelemar · Answer

Thanks, that work perfectly.

_anomdiebolt_ · Answer

Actually if you want to consistently round up you should use Ceil([Qty]/2) as Round([Qty]/2) rounds to the nearest integer.&nbsp;Round([Qty]/2) appears to work only because your&nbsp;[Qty] in an integer.

Forum Discussion

How to change a decimal to whole number

Related Content

Roundup whole number

Changing/setting record owner

Calculating number of days between two date fields

Historical Date Change Tracking

Add hyphens to phone number field