Discount to Client
 

Can someone please help me with a formula?

I am working on creating an order form. The client has an ID Code and I have
already calculated the discounts each client can receive. The ID Codes are
alphabetical.

All the data is stored on one worksheet and I want the cell on the new
worksheet to show how much discount they will receive, eg 5%, 10%.

Furthermore, I need to calculate the discount from the sub total to give a
grand total.

EG.

Data to retrieve:

A4 G4
VIP Code Discount
BARAN 12%


Thanks in advance for your assistance.

Marty

Discount to Client
 

Hi

Assuming your discount table is on Sheet1, in cells A4:G100
your client name is on Sheet2 in cell A1
your Subtotal value in on Sheet2 in cell E30

then in the cell where you want the Discount value to appear
=IF(A1="","",E30*VLOOKUP(A1,Sheet2!$A$4:$G$100,4,0 )

--
Regards

Roger Govier


"mda19652" wrote in message
...
Can someone please help me with a formula?

I am working on creating an order form. The client has an ID Code and
I have
already calculated the discounts each client can receive. The ID Codes
are
alphabetical.

All the data is stored on one worksheet and I want the cell on the new
worksheet to show how much discount they will receive, eg 5%, 10%.

Furthermore, I need to calculate the discount from the sub total to
give a
grand total.

EG.

Data to retrieve:

A4 G4
VIP Code Discount
BARAN 12%


Thanks in advance for your assistance.

Marty