Else IF function not working

I am trying to write a function so that the text adjusts itself based on if the language selected is English or French and THEN based on the type of form.

The formula will be put at multiple places in the form that have not been fully determined yet.

I was working on the formula in cell L28 to get it to register with Excel.

Pretty sure my logic is ok but my formula isn't computing.

Here's a bit of info to understand the formula :

My Excel is in french hence, SI = IF, ET = AND, the "x" are placeholders for the text that i'll put in , My first condition determines the language and the others determine the type of form that is selected.

The error message I'm getting is the one where excel asks if you're trying to write a formula and that if you aren't you need to put a ' in front.


=SI($B$1="Français";
SI(ET($E$1="T776";
"x";
SI(ET($E$1="T777";
"x";
SI(ET($E$1="T2125";
"x")));
SI(ET($E$1="T776";
"x";
SI(ET($E$1="T777";
"x";
SI(ET($E$1="T2125";"x")))))

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

The syntax is wrong. Try building it like this (I am guessing what you really want)

=SI(ET($B$1="Français";$E$1="T776");"x";SI(ET(...)))

But that's exactly what I suggested!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.