Questions

Need Help with Excel Nested IF/AND Statements

Tags:
+
0 Votes
Locked

Need Help with Excel Nested IF/AND Statements

Jmcle008
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")