Suppose I have a spreadsheet with four cells in it: a1, b1, c1 and d1.
I want D1 to copy what’s been written in c1. But if that’s empty, copy what’s in b1. If that’s empty, copy what’s in a1. And if that’s empty, leave itself blank.
I’ve managed to use the ifblank command to get a copy of a single cell, but I can’t figure out how to combine that with the contingency plan of moving to another cell upon encountering a blank space.
Any help?
Thanks!
Nested ifblanks: Cell D1 =ifblank(c1,ifblank(b1,ifblank(a1,"",a1),b1),c1) I’ve had better luck with if(len(c1)=0 rather than ifblank(c1,… But that may be me.
=if(a3="",if(a2="",a1,a2),a3)
Thank you both for the quick replies.
Peter Morris, I put yours in first because it was shorter. I tested it out and it works exactly like I need it to. Thanks!
You’re welcome.
Tell me, is three rows going to be enough, or will you need to extend it to an arbitrary number? I can do that too, if needed.
No. I’m creating a quarterly spreadsheet full of contracts. So I’ll only need three months and then a quarterly tabulation. But sometimes, things aren’t filled in on the last month of the quarter, so the cell needs to pull from a previous spreadsheet.
So long story short, three is just fine. It seems to be working perfectly.