ISBLANK Not Working Because of Non-blank Cells

Hi, I hope I worded the title right. I'm trying to learn proper forum etiquette, and do not want to be misleading (as I was on my last post accidentally). I have a spreadsheet that I'm trying to get an IF statement to work on, but unfortunately I just cannot get it to work for me. I'm attaching a small portion of the workbook for reference (don't worry, there's nothing important or personal in it). Anyway, I need an IF function (or something that works) in column Q that basically says, if P2 is empty, then give me the data from I2, but if there is something in P2, then return that number instead. Where it isn't working for me is I was using a ISBLANK function in column Q, but that doesn't quite work since none of the cells are actually blank. They are empty strings of other IF statements.

You can use this in Q2:

=IF(P2="",I2,P2)

Note that P2 looks like a number, but is actually a text value, as it is derived from concatenating other cells together.

Hope this helps.

Pete

HOLY COW THAT WORKED! I don't know why I didn't think of that. It's so simple! I guess I've just been overthinking it. It works beautifully now.

Thank you for the help, Pete_UK!!!! I'll be updating this thread to SOLVED.

Glad to help, and thanks for the rep.

Pete

No problem at all!