Nested IF Statement

Hi

I am trying to creat a spreadsheet to creat a calculation that I thought would be easy with an IF statement. Iam later going to write VBA to carry out the function but this is for an assignment where I first have to create a spreadsheet to do the function.

I have 2 fields customer type and number of books. Based on this my bookstore will alllocate a discount on customer orders. I need to say something like IF cust type is "Individual" and number of books is <5 =0, IF cust type is individual and number of books is >5<24 =15, IF cust type is individual and number of books is > 25 = 25. I need to continue this type of thing for another customer type. I have looked at the wizzard and have created a simple IF statement by stating if cust type is individual 1,2 all this did was brokedown the customer type into a number I stil cannot find out how to add the extra bit of the function into the IF statement.

Can anyone help or advise f I should use another function that IF such as LOOKUP

Thanks

Thanks for the reply that doesnt quite work in my scenario because the number of books for individuals to get discounts ar different to the discounts the other customer type (library, school or educational inst.) get.

eg individual only have 3 discount levels the other group have 5 the numbers breakdown differently

I had thought of a coding system a discount value could be two digits the first could be customer type the second the number of books (but a code eg <5 books code 1) I could then do something (notice my vaguesness!!) to say if first digit a and second digit 1 apply this and so on or even a lookup table with all possibilities in? but I couldnt find a function in the excel list that sounded like it did this.

Thanks very much

Thanks sooo much I think that will work I was trying ot do it using one table which wont have helped!!

Thanks again