Odd / Even Numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-1981033%22%20slang%3D%22en-US%22%3EOdd%20%2F%20Even%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20a%20formula%20where%20you%20can%20reference%20a%20cell%20and%20if%20the%20number%20in%20the%20cell%20is%20an%20odd%20one%20it%20would%20put%20the%20word%20odd%20in%20the%20current%20cell%20and%20if%20it%20is%20even%20the%20same%20thing.%26nbsp%3B%20I%20was%20trying%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dif(b5%3Dodd%2C%22Odd%22%2C%22Even%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20can't%20seem%20to%20get%20it%20working.%26nbsp%3B%20Is%20it%20possible%3F%26nbsp%3B%20I%20simply%20was%20to%20have%20the%20cell%20I%20am%20working%20in%20look%20at%20another%20cell%20and%20tell%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1981033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1981051%22%20slang%3D%22en-US%22%3ERe%3A%20Odd%20%2F%20Even%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981051%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839754%22%20target%3D%22_blank%22%3E%40Larry1921%3C%2FA%3E%26nbsp%3Btry%26nbsp%3B%3CSPAN%3E%3Dif(ODD(b5)%2C%22Odd%22%2C%22Even%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1981086%22%20slang%3D%22en-US%22%3ERe%3A%20Odd%20%2F%20Even%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981086%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839754%22%20target%3D%22_blank%22%3E%40Larry1921%3C%2FA%3E%26nbsp%3B%2C%20another%20alternative%20would%20be%3A%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(MOD(B5%2C2)%2C%0A%22Odd%22%2C%22Even%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1981186%22%20slang%3D%22en-US%22%3ERe%3A%20Odd%20%2F%20Even%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839754%22%20target%3D%22_blank%22%3E%40Larry1921%3C%2FA%3E%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20follow%20the%20attached%20file.%3C%2FP%3E%3CP%3EHowever%2C%20you%20may%20write%20the%20following%20formula%3A%3C%2FP%3E%3CP%3E%3DIF(ISEVEN(A3)%3DFALSE%2C%20%22Odd%22%2C%20%22Even%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ilgar_Zarbaliyev_0-1607721433244.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239922i3349DBCC47C159BC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ilgar_Zarbaliyev_0-1607721433244.png%22%20alt%3D%22Ilgar_Zarbaliyev_0-1607721433244.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1981583%22%20slang%3D%22en-US%22%3ERe%3A%20Odd%20%2F%20Even%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1981583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839754%22%20target%3D%22_blank%22%3E%40Larry1921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENumber%20formatting%20will%20display%20the%20words%20%22Odd%22%20and%20%22Even%22%20leaving%20the%20formula%20as%3C%2FP%3E%3CP%3E%3D%20MOD(number%2C%202)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to figure out a formula where you can reference a cell and if the number in the cell is an odd one it would put the word odd in the current cell and if it is even the same thing.  I was trying

 

=if(b5=odd,"Odd","Even")

 

But I can't seem to get it working.  Is it possible?  I simply was to have the cell I am working in look at another cell and tell 

5 Replies

@Larry1921 try =if(ISODD(b5),"Odd","Even")

@Larry1921 , another alternative would be: 

=IF(MOD(B5,2),
"Odd","Even")

@Larry1921

Hi there,

 

Please follow the attached file.

However, you may write the following formula:

=IF(ISEVEN(A3)=FALSE, "Odd", "Even")

 

Ilgar_Zarbaliyev_0-1607721433244.png

 

 

 

@Larry1921 

Number formatting will display the words "Odd" and "Even" leaving the formula as

= MOD(number, 2)

@Peter Bartholomew 

That's a great trick, I totally forget about it. Quite seldom used on practice.