Rounding to nearest 25,000

Quote:

---

Originally Posted by Joacim Andersson

MsgBox Int(theNumber) + 1

---

But what if the number is 5, then wouldn't this yield (5) + 1 = 6?

Quote:

---

Originally Posted by techgnome

I was smoking something when I wrote that.... the air has now cleared and I don't know *what* I was thinking.... but what will VB do to 18.5 vs 17.5 before doing int division?

-tg

---

I think both of those would round to 18. :ehh:

Quote:

---

Originally Posted by CJD#11

O.k., lets back off a little. Forget the whole 25000 thing. How about just a way to round any number UP every time?

Ex 4.1 = 5
4.3 = 5
4.6 = 5
5.1 = 6

From what I've read, there is no VB command to do this, so it has to be 'forced' to happen.

---

Dop a search for RoundUp and my name in this forum. I posted a routine recently that dioes that.