salary computation

[p adhikari]

sir kindly suggest formula for cpa & cpd computation as given below

salary+gp=10000+4845=14845

total*.1=14845*.1=1484.5

cpa=1484.5

cpd=cpa*2

the cpa & cpd value must be rounded to nearest 10

 

[Hui]

P adhikari


Firstly, Welcome to the Chandoo.org Forums


In the CPA cell =ROUND((Salary cell + GP Cell)*0.1,-1)

In the CPD cell =ROUND(CPA Cell * 2,-1)

 

[p adhikari]

thanks hui


i forgot to add DA cell

the edited post posted today