Rounding

Droopy · August 13th, 2003, 09:44 PM

hi i have a tricky problem
i am trying to round some numbers
but i want to round them up

eg..
if i had 1.1 i want it to round to 2
if i have 1.9 i want it to round to 2 again
if i have 1.0 i want it to round to 1

i have used Round() but it rounds 1.1 to 1
i have used Fix() + 1 but it rounds 1.0 to 2

the only way i can think of doing this is with a heap of complicated if statements and i dont want it to come to that

thanks for any help :)

rodmcleay · August 14th, 2003, 12:47 AM

I don't know of any inbuilt function but youe could use something like

Code:

function roundUp(num)
    dim arrNum, leftover
    arrNum = split(cstr(num),".")
    roundUp = arrNum(0)
    leftover = num - roundUp
    if leftover > 0 then roundUp = roundUp + 1
end function

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

pgtips · August 14th, 2003, 03:47 AM

Quote:

quote:if i had 1.1 i want it to round to 2
if i have 1.9 i want it to round to 2 again
if i have 1.0 i want it to round to 1

How about

Code:

x = IIf(n - Fix(n) > 0, Fix(n + 1), n)

where n is the number to be rounded and x is the result.

Droopy · August 14th, 2003, 08:45 PM

thank you both