>>>>>>>>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?? .....
>
>OOPS! (My turn!) After checking with the online help, I remarked that Floor() as the same functionality as Int()
OK, this thread is quickly becoming a very large clusterf***. Let's just chalk it up to enthusiasm. Right? OK.
Matt McDonnell
...building a better mousetrap with moldy cheese...