If odd then even...

[MKTetzlaff]

Hi:

I think that I am going about this wrong.

I have the length of a needed part (balance rod) in cell L127=rounddown((L108-2),0). We have switched vendors and now are only using even length balance rods.

L108 contains the product height divided by 2.
L127 (balance length) can never be less than 10 or more than 48.
L127 always needs to produce a even number but cannot be more than one less than actual number.

example: L127 = 27.375 --> rounddown to 27 (odd needs to be 26 so substract 1)
example: L127 = 36.875 --> rounddown to 36 (ok because it is even so substract 0)
example: L127 = 37.000 --> rounddown to 37 (odd needs to be 36 so substract 1)

If the part length (L127) is an even number, I do not need to do anything. If cell L127 is an odd number, I need to round down one / substract one to get to the even number below it.

I was thinking of trying to make the rounddown(), fix(), int() work in some combination but it also changes even numbers. This seems way too complicated for what appears to be easy on the surface.

I think I need some way to test if L127 is odd, maybe a If=odd/Then substract 1, If=even/Then substract 0.

I appreciate any help you guys can provide either on a way to test if a number (L127) is odd or just making this work in general.

Thanks in advance,

- Mike T.

 

[Lewiy]

Try this:

=IF(ISODD(INT(L108)),INT(L108)-1,INT(L108))

 

[gsbelbin]

If your actual length is in L127, I think all you need to do is

FLOOR(L127,2)

 

[Andrew Poulsom]

The Analysis ToolPak Add-In has ISEVEN and ISODD functions. Otherwise:

=MOD(INT(L127),2)

will return zero if even, otherwise 1.

 

[Lewiy]

I think all you need to do is

FLOOR(L127,2)

This doesn't work, take the example 27.375, FLOOR(L27,2) gives 24 which is not what is expected.

 

[gsbelbin]

This doesn't work, take the example 27.375, FLOOR(L27,2) gives 24 which is not what is expected.

Not on my PC, it gives 26

 

[cornflakegirl]

FLOOR works fine for me.

 

[Lewiy]

Not on my PC, it gives 26

Bizarre, it's working now.....not sure what happened!! My apologies!

 

[cornflakegirl]

We've told you before not to drink at lunchtime

 

[MKTetzlaff]

As always, thank you.