odd or even comment plugging

[makinmomb]

25
28
32
18
34
24
33
15
28
22
27
23
26
5
33
3
23
32
21
30
2
30
28

I have these , how do i term them odd and even on b1 downwards , assumming that data is on A1 downwards

[protonLeah]

Odd numbers have a remainder of one when divided by two...

Lookup MOD()

[makinmomb]

someone else ?

I need ODD and EVEN comment through formula

[AlKey]

try this

Please Login or Register  to view this content.

v	A	B
1	25	ODD
2	28	EVEN
3	32	EVEN
4	18	EVEN
5	34	EVEN
6	24	EVEN
7	33	ODD
8	15	ODD
9	28	EVEN
10	22	EVEN
11	27	ODD
12	23	ODD
13	26	EVEN
14	5	ODD
15	33	ODD
16	3	ODD
17	23	ODD
18	32	EVEN
19	21	ODD
20	30	EVEN
21	2	EVEN
22	30	EVEN
23	28	EVEN

[makinmomb]

Thank you ALKEY

[jason.b75]

someone else ?

A touch disrespectful, don't you think?

protonLeah suggested that you look up information on the MOD function, which would do what you asked for. Given the number of posts you have on the forum, writing a simple formula should be something you are capable of.

[makinmomb]

My apologies