[users] Doubt CALC.

[Roymon Mathew]

There is a doubt in preparing Salary Bill using  CALC.

   1. Entering  Basic Pay in col.A
   2. For calculating DA applying formula  =A1*55/100 in col.B
   3. Getting 55% of Basic Pay in col.B
   4. Decreasing the decimal places and gets round figure in col.B
   5. Calculating the sum in col.B by using autosum or formula  =sum(B1:B….)
   6. Getting the sum without considering the 4th step.

So there is a mistake. How can we solve it?