Question

Locked

Need Help with Excel Nested IF/AND Statements

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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums