Autofilter option

[Karthikeyan Devan]

Hi All,

I have an excel template where we use to calculate the discount rate. I need it to be calculate automatically.

Here is the scenario.

In Cell B1 i have an autofilter option which consit of customer names. (XYZ and ZZZ)

In cell B2 have an autofilter option which ask whether INTER or METRO.

In Cell B3 I have the autofilter which is system (SIEBEL or ORACLE).

In Cell B4, user will give the price.

Now, i need the discount price in Cell B5.

Here is what what i needed. Suppose,

If user choose XYZ as customer. If it is Inter in type and Siebel in system then 50% disconunt should apply in B5.

If user choose XYZ as customer. If it is Inter in type and Oracle in system then 40% disconunt should apply in B5.

If user choose XYZ as customer. If it is metro in type and Siebel in system then 60% of disconunt should apply in B5.
If user choose XYZ as customer. If it is metro in type and Oracle in system then 70% of disconunt should apply in B5.

If user choose ZZZ as customer. If it is Inter in type and Siebel in system then 40% disconunt should apply in B5.

If user choose ZZZ as customer. If it is Inter in type and Oracle in system then 30% disconunt should apply in B5.

If user choose ZZZ as customer. If it is metro in type and Siebel in system then 500% of disconunt should apply in B5.

If user choose ZZZ as customer. If it is metro in type and Oracle in system then 800% of disconunt should apply in B5.

I understand this is little bit confusing but i am not sure how to put this right way. Any VBA coding for this would be great help.

 

[Karthikeyan Devan]

Any help on this would be greatly appreciated