At 00:55 09/08/2009 +0530, Roymon Mathew 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?
I don't know about "So there is a mistake" -
since you haven't identified what's different or what you think is wrong!
If you change the number of fractional places
(your step 4) by changing the format of the
cells, you are simply altering the way that the
values are displayed: the values actually stored
in the cells are the unchanged accurate values,
as you would see with a suitably large number of
fractional places displayed. There are then two
different ways in which Calc can do calculations
on such values: either on the actual values
stored in the cells or on the rounded values
displayed. You can toggle between the two ways
at Tools | Options... | OpenOffice.org Calc |
Calculate | Precision as shown. Tick the box if
you want the rounded values to be summed; untick
it if you want the true values to be used.
Alternatively, of course, you may wish to modify
your formula to calculate the actual rounded
value for the values in column B: perhaps
=ROUND(An*55/100;2)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
