Formula to return non-blank value from multiple cells

MegBLLC

I have a number of columns in a row and only one of them will be not blank at any one time. I'd like to program another cell that will "look" at these cells and return only the value of the cell among those columns that is not blank. Is this possible?

AravindGP

Hi @MegBLLC

It is possible. You can write a nested IF formula to check the columns one by one and collect the value if it is not blank. Something like =IF([Column 1]@row <> "", [Column 1]@row, IF([Column 2]@row <> "", [Column 2]@row….