Can't use two drop downs to determine what's in another field with my IF statement

Hello,

I'm trying to use two drop downs with the number of students in one, and the number of classes in another, to determine what their monthly tuition and fees would be.

I've created a table with the costs. I did an IF statement that works as long as "1" is always selected in the first drop down. If I select "2" in the first drop down, the cell shows "FALSE." Here's a sample of the formula:

Please Login or Register  to view this content.

I'd love to be able to show the costs in one cell for September, for example, based on both the number of students and the number of classes. I've attached the spreadsheet as well. I'm really not the greatest with excel. Hopefully this has an easy solution. Anyone have suggestions?

Thanks,
Jeff

Put this formula in E2:

Formula:

Please Login or Register  to view this content.

and copy it down to E10.

Hope this helps.

Pete

EDIT: Oh, by the way, you need to ensure that you have a space either side of "and" in each of the cells on row 7.

Thank you so much. I've got no clue how that formula works but it does and I couldn't be happier. -- I'll be doing a little homework and trying to figure out how it all works so I can do it on my own in the future. Again, thank you very much.

@ llovetrain

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.