On Aug 31, 5:49*pm, Sean Timmons
wrote:
=ROUNDDOWN(AVERAGE(A1:C1)*2,0)/2
=ROUNDUP(AVERAGE(A1:C1)*2,0)/2

Should get you.



"Anthony" wrote:
How do I round an average of three numbers down to the nearest 0.50
assuming the three numbers are in cells a1, b1, and c1 and the formula
will be in cell d1. *Also, how do I do the same but round up to the
nearest 0.50.- Hide quoted text -

- Show quoted text -

Thank you very much for the assist. The formulas work perfectly.
JoeU, thanks for replying also.