hi guys,
can anyone help me about this code.
=IF(AND(B7="1",D7="OFF"),"OFF",A7,IF(AND(B8="1",D8="OFF"),"OFF",A8,IF(AND(B9="1",D9="OFF"),"OFF",A9,IF(AND(B10="1",D10="OFF"),"OFF",A10,
IF(AND(B14="1",D14="OFF"),"OFF",A14,IF(AND(B17="1",D17="OFF"),"OFF",A17,IF(AND(B22="1",D22="OFF"),"OFF",A22)))))))
its says youve entered to many arguments for this function.
and i dont know what to do.
Bookmarks