>>>>>>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?? .....
Matt McDonnell
...building a better mousetrap with moldy cheese...