Rounding Number

[jbc]

Hi,

I'm doing a number of calculations from a number entered into a text box. I
need to take that number

(X - 100)/50 This answer needs to be rounded UP to the next whole number.

For instance, If X = 312 the answer needs to be 4. Any decimal place needs
to be rounded up.

There is a ROUNDUP

 

[jbc]

PLEASE READ ABOVE POST.

 

[macropod]

Hi,

In vba, try:
-INT(-(X - 100)/50 )

For a field-based solution, download the Word document at:
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
(url all one line)

Cheers

 

[David]

Hi,

I'm doing a number of calculations from a number entered into a text box. I
need to take that number

(X - 100)/50 This answer needs to be rounded UP to the next whole number.

For instance, If X = 312 the answer needs to be 4. Any decimal place needs
to be rounded up.

There is a ROUNDUP

Search this group for ROUND NUMBER.
http://groups-beta.google.com/group...public.word.vba.general&q=round+number&qt_g=1