Rounding

Hiyas,

How do I round down? I don't want it to round up even if it's above 0.5 - if it's not whole it must be rounded down.

Thanks.

-Git

I'am sure there is a better way to do this but
you could try to use the VAL function... It will however
only recognize the PERIOD (.) as valid decimal separator !

Hope it helps

Hi,
Use

Code:

---

a = Fix(a)

---

This will remove any fractional part and just return the integer. ie 3.75, 3.4, 3.9999 all become 3

Hope this helps

Shaun

Use the Int() function

Code:

---

MyNum = 4.52
MsgBox Int(MyNum)

---