IF Odd or Even ... return value

[smithtm3]

On one workbook spreadsheet I have values that are Odd and Even.
I want two columns one for Odd and one for Even.
Currently I am using an IF statement that returns True or False.
Is it possible to return the values?

 

[Michael M]

Maybe something like

=IF(ISODD(A1),A1,B1)

 

[jolivanes]

If your data starts at A2:

In B2: =IF(MOD(A2,2)=0,"",A2)

Fill down.

In C2: =IF(MOD(A2,2)=0,A2,"")

Fill down.

 

[jolivanes]

Or:

Sub Maybe()
    With Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
        With .Offset(, 1)
            .Formula = "=If(Mod(RC[-1], 2)=0,"""",RC[-1])"
            .Value = .Value
        End With
        With .Offset(, 2)
            .Formula = "=If(Mod(RC[-2], 2)=0,RC[-2],"""")"
            .Value = .Value
        End With
    End With
End Sub

 

[smithtm3]

If your data starts at A2:

In B2: =IF(MOD(A2,2)=0,"",A2)

Fill down.

In C2: =IF(MOD(A2,2)=0,A2,"")

Fill down.

 

[smithtm3]

If your data starts at A2:

In B2: =IF(MOD(A2,2)=0,"",A2)

Fill down.

In C2: =IF(MOD(A2,2)=0,A2,"")

Fill down.

Worked GREAT! THANK YOU!

 

[jolivanes]

Your welcome.
Thanks for the feedback