One step further. Basically I have a Total and I want to make sure it is
divisable by 4.

What I'm doing is analysing the total needed for this 1 product. If the
total need for this product is lets say 10. But, we can only ship 4 in a buy
pack I want it to round to 12. If the total is 5 I want it to go to 8
preferablly verse going down to 4.

Hope that makes sense. Not sure if the ISODD or EVEN was helping.

Thanks for any help! :0)

"Ron Coderre" wrote:

How would you like to do that?

Here are some options:

Round up to the next even number?
R6: =CEILING(Q6/$C$3,2)

Round down to the next even number?
R6: =FLOOR(Q6/$C$3,2)

Round up/down to the nearest even number?
R6: =ROUND((Q6/$C$3)/2,0)*2

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"BSantos" wrote:

=IF(isodd(SUM(Q6/$C$3)),EVEN(R6))

I have this formula in cell R6. I want it to basically sum q6/c3 and if the
answer is an ODD number change it to an EVEN number. In that same cell "R6"

Any help! :0)

Bonnie