Nested if formula

[Gijs]

I can't resolve what I thought to be a simple formula:

Table
situation 1: B 1 C 1 D 1 E 1
situation 2: C 2 D 2 E 2
situation 3: D 3 E 3
situation 4: E 4
situation 5: B 5 C 5 D 5
situation 6: C 6 E 6
situation 7: B 7

What I want to obtain is: if B is empty, get C, if C is empty get D, if D is empty, get E
I'm applying the following formula: =IF(B1<>"",B1,IF(C1<>"",D1,IF(D1<>"",E1)))

result expected result
situation 1: B 1 B 1
situation 2: D 2 C 2
situation 3: E 3 D 3
situation 4: FALSE E 4
situation 5: B 5 B 5
situation 6: 0 C 6
situation 7: B 7 B 7

I hope someone can help me, thank you in advance,

Gijs

[Andrew-R]

Change your formula to:

=IF(B1<>"",B1,IF(C1<>"",C1,IF(D1<>"",D1,E1)))

[icestationzbra]

try:

Please Login or Register  to view this content.

or the fancier:

Please Login or Register  to view this content.

[zbor]

Or try:

=LEFT(TRIM(B1&" "&C1&" "&D1&" "&E1),3)