Picking only a odd number from a cell

[khank]

Hate to be so ignorant.

IF A1 has a number range of 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

In B1 I only want to show if the odd number...

Example: A1=3 then B1 would show 3. If A1=2 then B1 would be blank.

[OnErrorGoto0]

Hi,
=IF(MOD(A1,2)=1,A1,"")
should do that for you.

[khank]

Sorry - In A1 I placed "9" and the formula showed "0" not "9"

[OnErrorGoto0]

I do not see how that is possible (even with 2008). Can you please post a sample workbook?

[khank]

Sorry I got it to work. Thanks