Rounding problem

[AngiW]

This was working great, but not anymore.

I have a formula that displays how many days are avail.
I'm using:
Daysavail = Round(HoursAvail / PosHours, 0)

but it rounds up after .5 and that's not right. If it's .667 it says the
person has a day avail and they don't. How do I make it only display the whole
number of the formula result? I've set DaysAvail to byte, didn't help. I've
tried taking off the Round, that didn't help...still rounds to the next whole
number. Thanks for your time!

 

[Allen Browne]

To truncate the fractional part, use Int() instead of Round().

 

[Mike Sherrill]

On 08 Feb 2004 06:51:41 GMT, (e-mail address removed) (AngiW) wrote:

[snip]

Daysavail = Round(HoursAvail / PosHours, 0) [snip]
How do I make it only display the whole
number of the formula result?

Daysavail = Int(Round(HoursAvail / PosHours, 0))