Thread: [Solved] Excel 2010 formula rounds - arithmetic average calculation
View Single Post
 
Old 06-07-2011, 08:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,381
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi YooNaa Kim,

=(AVERAGE(C7:H7)*3+I7)/4 returns 7.5
=(ROUNDDOWN(AVERAGE(C7:H7),2)*3+I7)/4 returns 7.495

I'm not sure why you've got the extra math 7 INT function. If you want to limit the output to three decimal places, you could use:
=ROUND((ROUNDDOWN(AVERAGE(C7:H7),2)*3+I7)/4,3)
or
=ROUNDDOWN((ROUNDDOWN(AVERAGE(C7:H7),2)*3+I7)/4,3)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote