need help on if then formula

[needhelp14]

So I want to do the following.

In columns b1, c1, d1, e1, there will either be FALSE or a label. For this example, lets say it will be either FALSE or the label MATERIAL.

The sheet will look as follows


B1 C1 D1 E1
FALSE FALSE MATERIAL FALSE

So for A1 I want a formula that essentially says if FALSE shows in B1, take the value in C1. If FALSE is also in C1, take the value in D1. If FALSE is also in D1, take the value in E1.

Thanks in advance for your advice.

 

[aaronbens]

=if(b1=false,if(c1=false,if(d1=false,e1,d1),c1),b1)