I have a series of fields that looks something like the image below.
IF.jpg
Basically, if Colum I14 and I15 and I16 are all equal to "A" then place 25% in another field. But, If i14, 15, and 16 are equal to A and column K14, 15, 16 are equal to A then place 50% in the field and so on until we get to 100%. (see formula below)
I have a Nested IF statement which does not seem to be working.
=IF(AND(IF(AND(I14="A",I15="A",I16="A"),25,0)),IF(AND(K14="a",K15="a",K16="a"),50,25),IF(AND(M14="A",M15="A",M16="A"),75,50)),IF(AND(M14="A",M15="A",M16="A"),100,75))
It is saying there are too many functions within the one statement. I there a better way I can be writing this formula?
Bookmarks