Round Up and Down

[Heather]

Hi Can anyone tell me how to roundup and rounddown depending on if a number
is greater than = .50 then roundup >.49 rounddown.

1.69 = 2
1.5 = 2
1.2 = 1
1.49 = 1

Thanks in advance!

 

[Dave Patrick]

This link may help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctround.asp

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi Can anyone tell me how to roundup and rounddown depending on if a
number
| is greater than = .50 then roundup >.49 rounddown.
|
| 1.69 = 2
| 1.5 = 2
| 1.2 = 1
| 1.49 = 1
|
| Thanks in advance!
| --
| Heather

 

[peregenem]

Hi Can anyone tell me how to roundup and rounddown depending on if a number
is greater than = .50 then roundup >.49 rounddown.

1.69 = 2
1.5 = 2
1.2 = 1
1.49 = 1

Thanks in advance!

What about negative values? Bankers' rounding for fairness?

Suggested reading:

http://support.microsoft.com/default.aspx?scid=kb;en-us;196652