General information
Category:
Coding, syntax & commands
>>>>>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 ;)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only