Thanks so much, David!!! This works very well. I really appreciate it. You
are the man!!!
riffmasrt7

"David Biddulph" wrote:

Why don't you just replace the A2 in my formula by your AVERAGE function?

=IF(OR(MOD(AVERAGE(57,52,52,49),1)<0.5,ISODD(AVER AGE(57,52,52,49))),ROUND(AVERAGE(57,52,52,49),0),R OUNDDOWN(AVERAGE(57,52,52,49),0))
--
David Biddulph

riffmastr7 wrote:
Hi, David. Very good! This works! I want to take it one step further
and make it a calculation formula. I want to make the average of 4
numbers to follow the same rounding rule.

Example: 57, 52, 52, 49

The average of the numbers above is 52.5. I want to put it in a single
formula to average them and come out as 52.

Please help.

"David Biddulph" wrote:

Again reluctant to argue with an MVP, Ashish, but for the second
time this morning I'm not convinced by your answer. Have you had a
long week? :-)

If there isn't a .5 at the end, you should round to the nearest whole
number. It is only when there is a .5 that you should look at odd
or even. You are rounding 54.9 to 54 when it should be 54, and you
are rounding 55.1 to 56 when it should be 55.

Try =IF(OR(MOD(A2,1)<0.5,ISODD(A2)),ROUND(A2,0),ROUND DOWN(A2,0))
--
David Biddulph

Ashish Mathur wrote:
Hi,

Sorry I did not get your question right. Please try this formula

IF(ISEVEN(INT(G7)),INT(G7),INT(G7)+1)


"riffmastr7" wrote in message
...
Hi, Ashish. Please read my example very carefully. I need excel to
round 54.5
to 54. This is called ASTM rounding rules. It only becomes tricky
when there
is a 0.5 in the end. Basically, when there is a .5 in the end, the
number is
rounded to the nearest EVEN WHOLE number. Here it is again:

Example:

If the average is 54.5, I need excel to round it to 54.
If the average is 55.5, I need excel to round it to 56.

"Ashish Mathur" wrote:

Hi,

Not clear about your question. Why should 5.5 be 54 and 55.5 be
56. If 55.5 is 56, then 54.5 should be 55?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"riffmastr7" wrote in
message ...

Hi, I need to apply the rounding rule below for conducting our
business when
dealing with a number that has a 0.5 ending:

Example:
If the average is 54.5, I need excel to round it to 54.
If the average is 55.5, I need excel to round it to 56.

Please help! Thanks.