T
TQ
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 !
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 !