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