Need Help with Excel Nested IF/AND Statements - TechRepublic
Question
December 14, 2012 at 07:36 AM
jmcle008

Need Help with Excel Nested IF/AND Statements

by jmcle008 . Updated 13 years, 6 months ago

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 discussion is locked

All Comments