Check multiple cells to show the one with a result

Hello,

I need help with a formula.

 

There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as result the value of the cell with a result. 

 

Something like:

 

If cell A <>”” , cell B<>””, cell C<>””, cell D<>””, value if true, cell, A, cell B, cell, C, cell D, value if false “”

 

 

By: Randall

Leave a Reply

Your email address will not be published. Required fields are marked *