Check multiple cells to show the one with a result


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 *