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