Rounding problem

  • Thread starter Thread starter AngiW
  • Start date Start date
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!
 
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?
Click to expand...

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