Rounding problem

A

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!
 
M

Mike Sherrill

On 08 Feb 2004 06:51:41 GMT, [email protected] (AngiW) wrote:

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

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