>>>>>>>I have a program that calculates a bunch of dollar figures as well as many whole number counts. Somehow I need the dollar figures to always round down(ie. 98.768 = 98.76), and the whole number counts to round up(55.6 = 56). These calculations are spread throughout the many forms and pages that make up the application. I am hoping for some type of SET option.
>>>>>>>
>>>>>>>Shane
>>>>>>
>>>>>>SET FIXED TO 2
>>>>>
>>>>>OOPS...
>>>>>
>>>>>SET DECIMALS TO 2
>>>>>SET FIXED ON
>>>>
>>>>OOPS again... FIXED rounds it up...sorry
>>>
>>>
>>>One more...
>>>
>>>nDollars = 12.237
>>>
>>>nFixedDollars = (INT((nDollars)*100))/100
>>>
>>>nFixedDollars = 12.23
>>>
>>>I KNOW that works
>>
>>Yes it work, but Floor(nDollars) is easier ;)
>
>OK, I give up. What's the practical difference between floor() and int()?
>
>... where the hell is my user's manual anyway?? .....
If numbers less than zero, can be different results...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.