Return the value from the column that is not blank

System

This discussion was created from comments split from: If multiple cells are not blank - check the box.

Haley Gehris

I am trying to evaluate 3 different columns and I want the value from the column that is not blank to be returned. There will only be a value in 1 of the 3 columns. How can I string IF statements together and use the ISBLANK formula to accomplish this?

ShaneP

If there is only ever 1 cell that will have a value, can't you just add each cell together? E.G you have column A,B,C. Create Column D which has =A+B+C