Round up & Autosum


G

Guest

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 !
 
Ad

Advertisements

B

Bob Phillips

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

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top