Nested IF Statement Alternative

[Gecks]

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?

[dilipandey]

Hi Gecks,

Welcome to the forum.

Try looking at following formula and enter value if "input req."appears, test it out and let me know for further help. thanks.

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Gecks]

Thank you so much for the response.

However, inputting the changes to teh formula as I did below only returned 25% when it should have returned 75% based on the entries.

=IF(AND(I14="A",I15="A",I16="A"),25,IF(AND(K14="a",K15="a",K16="a"),50,IF(AND(M14="A",M15="A",M16="A"),75,IF(AND(N14="A",N15="A",N16="A"),100,"input req."))))

[Gecks]

I figured out a way to do it... it will add 25% when each criteria is met. It works!!!

=IF(AND(I14="A",I15="A",I16="A"),25,0)+IF(AND(K14="a",K15="a",K16="a"),25,0)+IF(AND(M14="A",M15="A",M16="A"),25,0)+IF(AND(N14="A",N15="A",N16="A"),25,0)

[dilipandey]

Hi Gecks,

I suggest you to post this as a sample file as I foresee that you may land in trouble in future because you have chosen to appear 25 on every condition and forget to include 50 75, and 100. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>