Question Locked

Need Help with Excel Nested IF/AND Statements

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using Excel for Trainng Registers, but having problems getting the right formula in excel. I have 2 drop downs, 1 for Training Type and 1 for State. Each gives me a Number depending on the selection of each and I want a cell to give me the right pricing by the #'s of both selections. This is what I have and obvisouly not working. Any help would be greatly appreicated.

=IF(Sheet4!A7=1 AND Sheet4!M59,=<8, "100","200",IF(Sheet4!A7=2 AND Sheet4!M59,=<8, "300","400",IF(Sheet4!A7=3 AND Sheet4!M59,=<8, "500","600",IF(Sheet4!A7=4 AND Sheet4!M59,=<8, "700","800",IF(Sheet4!A7=5 AND Sheet4!M59,=<8, "900","1000")

1 reply

This discussion is closed to new replies.