Calculation error in CTC structure, though the figure is same.

[Ravichandra Paanem]

Dear Members,

I am preparing CTC structure for my company and had an error while testing it.

I gave an annual CTC figure in a cell which has formulas underneath it. when i gave a certain figure for ex:250000 i am getting a figure in Gross Salary. I am happy with that. But when i increase the figure to 255000 Gross salary has been changed, but the problem now is when i re-enter 250000 again in the CTC cell, the Gross Salary figure is differed from earlier.

I am unable to figure out the error and why is it occurring.

can someone help me in getting it resolved.

Thanks
Ravichandra

 

[NARAYANK991]

Hi ,

Can you upload your workbook ?

Narayan

 

[Ravichandra Paanem]

Hi Narayan,

Please find the workbook attached.

Try with 250000, 270000, 280000 and 270000 again in (E1) you can see the difference in cell(C8)

Ravi

 

[vletm]

@Ravichandra Paanem
[D2] =ROUND((E1-D13)*30%;0)
[D8] =SUM(D2:D7)
[C8] =ROUND(D8/12;0)
Is [D2] value same if [E1] 270000->280000 and [E1] 280000->270000 ?

 

[Ravichandra Paanem]

Hi,

I am checking C8 value by changing values in E1.

 

[vletm]

Yes!
What will happen after You change E1?
What will happen after that ...
and finally what will be C8
If You do that with different order, is it same? No!

 

[Ravichandra Paanem]

When i enter 270000 in E1, D8 is 248477 and C8 is 20706.
if i give 280000 in E1, D8 is 269920 and C8 is 22493. up to here i dont have a problem.

but again if i re enter 270000 in E1 values are getting changed in D8 and C8 to 260280 and 21690 respectively.

 

[vletm]

What are values in D2?
E1 => 270000 D2 = ?
E1 => 280000 D2 = ?
E1 => 270000 D2 = ?
E1 => 270000 D2 = ?
Why/What D2?
As I already wrote... #4 reply
[D2] =ROUND((E1-D13)*30%;0)
[D8] =SUM(D2:D7)
[C8] =ROUND(D8/12;0)
Then You change E1, Okay?
Then D2 will change too ..*30%
Then D8 will change sum(D2:D7)
Then C8 will change Round(D8/12,0)
What happens next then You will change E1 ... ?
and
again backward E1, are ALL those values same like before 1st change?