I wanna use this formula on Excel 2007, but i know excel 2007 only 7 levels if.
how to solve this formula?
thanks before
=IF(AND(H4<>"";D8="store name");E8;IF(AND(H4<>"";D9="store name");E9;IF(AND(H4<>"";D10="store name");E10;IF(AND(H4<>"";D11="store name");E11;IF(AND(H4<>"";D12="store name");E12;IF(AND(H4<>"";D13="store name");E13;IF(AND(H4<>"";D14="store name");E14;IF(AND(H4<>"";D15="store name");E15;IF(AND(H4<>"";D16="store name");E16;IF(AND(H4<>"";D17="store name");17;IF(AND(H4<>"";D18="store name");E18;IF(AND(H4<>"";D19="store name");E19;IF(AND(H4<>"";D20="store name");E20;IF(AND(H4<>"";D21="store name");E21;IF(AND(H4<>"";D22="store name");E22;IF(AND(H4<>"";D23="store name");E23;IF(AND(H4<>"";D24="store name");E24;IF(AND(H4<>"";D25="store name");E25;""))))))))))))))))))
Bookmarks