Rounding to the 4th decimal place

[Guest]

I have spent lots of time in the forum reading up on rounding but I can't
seem to figure this one out.

I have a fee for customs that should be $11.65 but the number I am computing
is $11.64

dRate = .0021
cTariffVal = 5545

cAmt = Round(dRate * cTariffVal,2)

The cAmt comes out to 11.64 when it should be 11.65 because the rate times
the value = 11.6445 before rounding

Any suggestions/information/resolutions is GREATLY appreciated!!!!!

Janis in MinneSNOWta (and ready for spring!!!!)

 

[Guest]

The cAmt comes out to 11.64 when it should be 11.65 because the rate times

the value = 11.6445 before rounding

You are not thinking about this correctly. 11.6445 does round to 11.64.

You are probably thinking that you should round to two decimal places in
steps: 11.6445, then 11.645, then 11.65. This is not how rounding works.
You always go back to the original number to round. So, in your case, you
look at 11.644, and round that to 11.64.