Hello everyone!

I want to calculate an arithmetic average using the following formula: arithmetic average of the columns, multiplied by three, and the result together with another value, all divided by 4. Unfortunately the formula that I used it, calculating the arithmetic average does not appear correct value. Please, if anyone can help me? I really need this formula.

Thanks in advance for the answers!

Attached Images

Capture0.jpg (73.5 KB, 11 views)

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]