I am trying to create this function:
=
IF(D11=xxx;E6;
IF(D11=xxx;E5;
IF(D11=xxx;E7;
IF(D11=xxx;E8;
IF(D11=xxx;E9;
IF(F11=xxx;E10;
IF(F11=xxx;E11;
IF(F11=xxx;E12;
))))))))
So it means several IF functions in one formula. But I need more IF, not only 8. I need double. But it I continue the same way, i got error:
The formula you typed contains an error ...
Can someone help? Is there any limitation for IF function in one formula?
Thank you
Bookmarks