Rounding

[squirrel74]

I need a formula that will only round if the decimal of the result is greater
than something ##.5, otherwise I don't want the formula to round. Below is an
example of what I've developed so far, but I need to know how to enter in a
value into the formula to indicate a number with a decimal greater than .5

=IF(AVERAGE(B11)>=##.5,ROUND(AVERAGE(B11),0),AVERAGE(B11))

Ultimately what the formula will needs to do is average 3 numbers, rounding
up only if the resulting decimal value is greater than .5, otherwise, the
formula should not round at all.

Example:
When I enter the following numbers the results will round due to the decimal
being greater than or equal to .5
(90 + 76 + 70)/3 = 78.6667
Result to display will be 79

However if I enter the following numbers the results will not round due to
the decimal being less than .5
(85 + 80 + 70)/3 = 78.3333
Result to display will be 78.3333

Thank you to anyone that can help.

 

[CLR]

Maybe....

=IF((A1-INT(A1))>=0.5,ROUNDUP(A1,0),A1)

Vaya con Dios,
Chuck, CABGx3

 

[JE McGimpsey]

One way:

=ROUND(AVERAGE(B11),15 - 15*(MOD(AVERAGE(B11),1)>=0.5))