>>>I have a program with the following line of code:
>>>
>>>lPayment_Amount = lpct * tpd_payments_lte.weekly_ttd_rt
>>>
>>>When I run my program and check the debugger, the following values are used:
>>>
>>>10.8539997 = 0.04998 * 217.18
>>>
>>>When I ROUND(lPayment_Amount,2) I get 10.85.
>>>
>>>But when I do the math using the Windows 95 calculator (0.04998 * 217.18) I get 10.8546564 which should round to 10.86.
>>>
>>>Any ideas on how I can fix this?
>>>
>>>Thanks!
>>>
>>>Jeff Rusch
>>>UW-Madison
>>
>>Actually 10.8546564 rounded to 2 decimals does round to 10.85. if you round it to 3 decimals, it rounds to 10.855
>
>
>This rounding thing is a problem of consisteny else where. Excel would respond with 10.85, quicken say for 10.8546 .. that 6 rounds the 4 to 5, 5 to 6 and responds with 10.86. Not sure who makes sense except that quick matches my bank statement interest and excel doesn't. go figure
>Gary

If you want to round to upper x/100, try this:
ceiling(10.8546564*100)/100

:-)