Producing discount code in visual basic

Hi,

I am trying to write and function in Visual Basic that takes customer type and number of items purchased as inputs, and returns the correct level discount that should be given.

The discount given is based on the type of customer and the amount of items purchased. For example:

Customer1
More than 50 items - 30%
25 to 49 items - 20%
15 to 24 items - 15%
5 to 14 items - 10%
Less than 5 items - 5%

Customer2
More than 25 items - 25%
5 to 24 items - 15%
Less than 5 items - 0%

I have, so far, managed to produce code that takes the number of items purchased as an input, but I am unable to produce code that takes customer type as an input.

Any help would be greatly appriecated.

Thank you,

Paul

Thank you for your responses.

I have entered the code in Visual Basic and I am now trying to incorporate the function into my excel spreadsheet. However, I am having a few problems with producing a formula.

I need to be able to enter either 'Customer1' or 'Customer2' into the 'Customer Type' cell and the number of items in the 'No. of Items' cell, then using the VB function return the correct level of discount in the 'Discount' cell.

I am just not sure how best to go about this.

I have attached a copy of my spreadsheet with the VB discount function.

Thank you,

Kind regards,

Paul

Thank you so much.

This has really helped me out.

Kind regards,

Paul