C1= A1*B1
C2= A2*B2

C1 =231.384
C2 =204.972

C1 and C2 = (column format 2 decimal)

so would be
C1 =231.38
C2 =204.97

the result
---A-----------B------C-----
1)24.880 9.30 231.38
2)22.040 9.30 204.97

Now i add D3=SUM(C1:C2) but i only want sum C1+C2(with 2decimal)
but the result will show D3=436.36 which mean it sum 3rd decimal too,
it should be D3=436.35 , how to do with these?


Now C1=231.39 how to make it become 231.38?
because the 3rd decimal is 0.004 should not bring +1 to front.

i only left this , anyone please help.. thanks
hope you all understand my english = ="

This post has been edited by calvinkli: Feb 3 2009, 01:08 PM

why dunt you right click the cells and select cell format. choose numbers and select the decimal from there?
in fact all acounting sheets will have to work on 2 decimals and fancy formulas will lead to error.


This post has been edited by beatlesalbum: Feb 3 2009, 02:22 PM


Attached thumbnail(s)

You can use the function ROUND.

Try C1=ROUND(A1*B1,2)

yea. i also just figure out , thanks ^^ still got roundup , excel many thing to play.
thanks to all whoever try to help me.

@beatlesalbum , thanks but that not what i want = ="

D3=ROUND(C1,2)+ROUND(C2,2)

This post has been edited by QsasaQ: Feb 3 2009, 05:47 PM

yeah, the exact function is round, not ceiling.
if its 293.453; ceiling will be 293.46() but round will make it 293.45 ()..
the beatlesalbum's way i think is also easier, and more user-friendly.