jeudi 7 avril 2016

Nesting Multiple If Statements with multiple outcomes

I need help on nesting these IF statements. I was able to get the first work to output what I wanted but am stuck with how to nest the second one. When I nest them together and input the data to make the second statement TRUE, I get FALSE as an output.

=IF(AND(B2>=19,B2<=25),IF(AND(B20>=90,B20<=99),B22+900,IF(AND(B2>=19,B2<=25),IF(AND(B20>=80,B20<=89),B22+400,IF(AND(B2>=19,B2<=25),IF(AND(B20>=70,B20<=79),B22+200,IF(AND(B2>=19,B2<=25),IF(AND(B20<=69),B22+100))))))))

=IF(AND(B2>=26,B2<=28),IF(AND(B20>=90,B20<=99),B22+500,IF(AND(B2>=26,B2<=28),IF(AND(B20>=80,B20<=89),B22+200,IF(AND(B2>=26,B2<=28),IF(AND(B20>=70,B20<=79),B22+75,IF(AND(B2>=26,B2<=28),IF(AND(B20<=69),B22+50))))))))

Aucun commentaire:

Enregistrer un commentaire