I have an interesting conundrum with the Excel round function.
I have three numbers - Hourly Rate (HR), Hours Worked (HW) and Burdened
Labor Rate (BLR). HR =56.50, Hw = 95, and BLR = 1.51.
When I calculate ROUND(HR*HW,2) which I will label "A" and then multiply
that by the BLR using ROUND( A*BLR,2) I get 8104.93. However, when I
calculate ROUND(HR*BLR,2) which I will label "B" and then multiply that by
the HW using ROUND(B*HW,2), I get 8105.40.
Why is that and how do I get equal numbers using the two methods.
Unfortunatley, I have use the two different methods in two different places
of a report.
--
Paul