A B C D E F
BASIC GP TOTAL DA CPA CPD
15650 4800 20450 9203 2965 5931
CPA COMPUTATION IS
=SUM(C+D)*10/100 THIS VALUE HAS TO BE ROUNDED
CPD =ROUND(E*2)
KINDLY SUGGEST FORMULA FOR ROUNDED CPA COMPUTATION
THANKS
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