Excel Question

[shorty_mcshort]

I have a list of integers in a column in excel and I want to differentiate in another column whether each integer is either even/odd (by using an E or O). What is the best way to do this? For some reason I can't figure out how to do it?

Thanks
Eric

 

[deblanka]

Something like this will work:

If the number is in A1 then in A2 type

=IF(MOD(A1,2)=1,"Odd","Even")

 

[shorty_mcshort]

Quote from deblanka:

Something like this will work:

If the number is in A1 then in A2 type

=IF(MOD(A1,2)=1,"Odd","Even")

Cool thanks I knew there was an easy way to do it. Works great.