Hi, how to make the figure to cut off with 3 decimal points and auto round up
if /=0.005 ? Example as below,

A1=0.0115 , B1=1.22 , C1=2.44 D1=1494
A2=0.0115 , B2=1.22 , C2=2.44 D2=1494
A3=0.0145 , B3=1.22 , C3=2.44 D3=1188
A4=0.0175 , B3=1.22 , C3=2.44 D3=972

E1=A1*B1*C1*D1/1000 (51.144)
E2=A2*B2*C2*D2/1000 (51.144)
E3=A3*B3*C3*D3/1000 (51.278)
E4=A4*B4*C4*D4/1000 (50.635)

E5=SUM(E1-E2) with 3 decimal points.

Can I get the answer E5=204.201 instead of 204.203 ? Any formula ?

Thanks !

=SUMPRODUCT(ROUND(E1:E4,3))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TQ" wrote in message
...
Hi, how to make the figure to cut off with 3 decimal points and auto round
up
if /=0.005 ? Example as below,

A1=0.0115 , B1=1.22 , C1=2.44 D1=1494
A2=0.0115 , B2=1.22 , C2=2.44 D2=1494
A3=0.0145 , B3=1.22 , C3=2.44 D3=1188
A4=0.0175 , B3=1.22 , C3=2.44 D3=972

E1=A1*B1*C1*D1/1000 (51.144)
E2=A2*B2*C2*D2/1000 (51.144)
E3=A3*B3*C3*D3/1000 (51.278)
E4=A4*B4*C4*D4/1000 (50.635)

E5=SUM(E1-E2) with 3 decimal points.

Can I get the answer E5=204.201 instead of 204.203 ? Any formula ?

Thanks !