Need to chose one data element from 3 columns

Closed
Jimmy - Jun 24, 2010 at 03:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 24, 2010 at 06:20 PM
Hello,

I have an Excel spreadsheet where I want to populate Column D on my spreadsheet. Column D should be populated by 1) Column A if there is a value, or 2) by Column B if Column A is blank, or 3) by Column C if Column A&B are both blank. Any help is appreciated.

EX:
A B C D
4 4
1 2 1
1 3 6 1
9 9
5 8 5

4 4


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 24, 2010 at 06:20 PM
you can use formula in D

for example in D2

=IF(A2<>"", A2, IF (b2<>"", b2, if(c2<>"", C2, "")))
0