How to round 8.93 to 8?

[nybcnow]

I have series of real numbers ranging from 0 to 20. I can't seem to figure out the way to rounddown all of them. For example, I need "7.93" to round to the lowest integer, "7". I wrote a macro but it did not round down but it did work. Below is the code. If someone knows of a way to rounddown without a macro, it would help alot.

Regards,
Greg

Function RndDuration(rndnumber)
Dim number As Integer

Do While rndnumber > number + 1
If rndnumber > number And rndnumber < number + 1 Then
rndnumber = number
Else: number = number + 1
End If
Loop

rndnumber = number
End Function

[qwopzxnm]

There is a function you can use ROUNDDOWN

=ROUNDDOWN("your cell here",0)

[nybcnow]

I tried Rounddwon function but I get "undefined function" message box. I use 2003 access. Any other ideas are welcomed.

Thanks so much
Greg

[nybcnow]

There is a function you can use ROUNDDOWN

=ROUNDDOWN("your cell here",0)

I tried Rounddwon function but I get "undefined function" message box. I use 2003 access. Any other ideas are welcomed.

Thanks so much
Greg

[jasoncw]

You could use:

=FLOOR(A1,1)

or

=INT(A1)

Assuming A1 is the cell you wish to round down.

HTH

Jason

[qwopzxnm]

So are you using Microsoft Excel or Access?

I tried Rounddwon function but I get "undefined function" message box. I use 2003 access. Any other ideas are welcomed.

Thanks so much
Greg

[nybcnow]

You could use:

=FLOOR(A1,1)

or

=INT(A1)

Assuming A1 is the cell you wish to round down.

HTH

Jason

Jason,

Thanks so much. INT worked! Good day to you

[nybcnow]

So are you using Microsoft Excel or Access?

I was in access. Sorry if I didn't make it clear. Jason suggested INT function and it worked like a charm. In any case, thanks so much for you help.

Regards,
Greg