ISODD and EVEN formula

=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

I'm not sure that the isodd function exists, unless it is an UDF but if I am understanding you correctly you want to find what Q6/C3 equals, and if it is even then you want that number displayed and if it is odd you want to move it up to the next even number (?)

If so then this should work:

=EVEN(Q6/$C$3)

I'm not sure that you need the SUM function in there and if you are writing that equation in cell R6 then you will be creating a circular reference when referring to EVEN(R6)

Does this help?

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

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

If the total is in Q6 then:

=ROUNDUP((Q6/4),0)*4

Then try this:

Round up to the next multiple of 4
R6: =CEILING(Q6/$C$3,4)

Is that what you're looking for?

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

XL2002, WinXP-Pro


"BSantos" wrote:

> 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

Maybe this in R6 will do as you wish...........it adds a 1 to any odd result
moving it to the next higher EVEN number, otherwise displays the EVEN
result...........

=IF(ISODD(Q6/C3),Q6/C3+1,Q6/C3)

Vaya con Dios,
Chuck, CABGx3



"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