rounding of average value

[p adhikari]

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

 

[greg.begin]

=ROUND(SUM(C+D)*10/100,1)


put round in front of your sum equation. then after the equation you need to put the number of digits(decimal places) you want rounded to.

 

[Luke M]

CPA formula condensed:

=(C2+D2)/10


CPD formula:

=ROUND(E2*2,0)

or

=ROUND((C2+D2)/5,0)


Next time, please turn off your CAPS lock so it doesn't look like you're yelling at us.

Thanks.

 

[Hui]

Don't forget with Round you can use -'ve integers to round to the Units, Tens, Hundreds etc


CPD formula:

=ROUND(E2*2,-1) round to the 10's

=ROUND(E2*2,-2) round to the 100's