Cell 1 to equal Cell 2, if 2 blank, then 3, if 3 blank, then 4

Kylie English

Hi all,

I have 4 cells, what I need is:

Cell 1 to equal Cell 2

If Cell 2 is blank, then read Cell 3,

If Cell 3 is blank, then read Cell 4.

I have searched quite a few discussions to try and replicate but cannot seem to get it to work.

Cell 1 - Approval Status

Cell 2 - Approver 1

Cell 3 - Approver 2

Cell 4 - Approver 3

Any help to resolve would be greatly appreciated!

Paul Newcome

Try something like this...

=IF(ISTEXT([Approver 3]@row), [Approver 3]@row, IF(ISTEXT([Approver 2]@row), [Approver 2]@row, [Approver 1]@row))