A nesting IF formula that will only put info if another cell has info...

[greenfox74]

This is the formula i wrote.

=IF(ISEVEN('#1A-UD'!C700),"='Numbers UD-EO'!B700",IF(ISODD('#1A-UD'!C700),"='Numbers UD-EO'!B700",""))

What it's supposed to do is if a cell in sheet 2 column C has a number in it, then B from the same sheet and same row will get the number from B of sheet 1.

When i put the formula in it only shows the formula and doesn't do anything. This is only like the 4th formula i have written, so I'm sure it's owner/operator failure. I just can't see where i messed up in the formula.

[Pete_UK]

You have two different sheet names there, so how can it get data from column B of the same sheet? I think what you are trying to do is this:

=IF('#1A-UD'!C700="","",'#1A-UD'!B700)

assuming the sheet name is #1A-UD.

Hope this helps.

Pete

[greenfox74]

Thank you again Pete_UK for helping me.
This is what I'm trying to do. I don't know if it makes sense or not. I put a section of both sheets on one sheet so ya'll wouldn't have to swap back and forth.

[Pete_UK]

This is the formula to put in Q11:

=IF(R11="","",B11)

If R11 is empty then Q11 will also appear blank, but put a number in R11 and Q11 will show the value from B11. Obviously, you will need to change the cell references to include sheet names in your real file.

Hope this helps.

Pete

[greenfox74]

If you only knew how much hand typing you are saving me. I could never thank you and any others that have helped me enough. You guys are geniuses!!!! Thanks so much for your time and help Pete_UK!!!