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.
Bookmarks