IF formula results in no action

[mombo]

I'm new to writing formulas in Excel, and I can't figure out how to have nothing change in one cell if the contents of another don't meet my criteria.

IF (the value in B1) ISODD, C1=B2; if the value in B1 is NOT odd, take no action.

How can I do that? I'm using Excel 97!

 

[Fluff]

Put this in C1
=IF(ISODD(B1),B2,"")

 

[Fluff]

You have to install the Analysis Toolpak. for the formula in post#2 to work

 

[Jonmo1]

Hmm, didn't know that..

=IF(MOD(B1,2)=1,B2,"")

 

[mombo]

You have to install the Analysis Toolpak. for the formula in post#2 to work

I have the Analysis Toolpak already installed, but when I copied and pasted your formula, I got an error message (#VALUE!) but not the solution I was hoping for.

Any other recommendations?

 

[mombo]

I DID IT!!! I had the values in the wrong columns, or the wrong cell references in the formula, but after I corrected things, IT WORKED!!! Thank you so much!!!

 

[Fluff]

Glad you got it working & thanks for the feedback