--On Sunday, August 09, 2009 12:55:10 AM +0530 Roymon Mathew
<[email protected]> wrote:
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?
In step 2 enclose the calculation in a round() function call specifying two
digits after the decimal point.
--
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
