View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Average rounded to nearest 0.50

=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.