Hi all
I have a multiple "IF" formula as below and excel says: "too many arguments...". What's your solution for this problem?
=IF(C2="X",IF(I2<='Definition-S,P'!A4,1,IF(I2<='Definition-S,P'!A5,2,IF(I2<='Definition-S,P'!A6,3,IF(I2<='Definition-S,P'!A7,4,IF(I2<='Definition-S,P'!A8,5))))),IF(C2="Y",IF(I2<='Definition-S,P'!A13,1,IF(I2<='Definition-S,P'!A14,2,IF(I2<='Definition-S,P'!A15,3,IF(I2<='Definition-S,P'!A16,4,IF(I2<='Definition-S,P'!A17,5)))))),IF(C2="Z",IF(I2<='Definition-S,P'!A22,1,IF(I2<='Definition-S,P'!A23,2,IF(I2<='Definition-S,P'!A24,3,IF(I2<='Definition-S,P'!A25,4,IF(I2<='Definition-S,P'!A26,5)))))),"")
Bookmarks