I need to make an order form

Closed
Ollie - Oct 25, 2009 at 10:29 AM
 Trowa - Oct 27, 2009 at 10:00 AM
Hello,

I need to create an order form. In this form I want my customers to be able to use a coupon which will vary from time to time. My problem is how do I express this on my formula page? Say for instance the coupon will give them 10% off any product ordered. Please help if you understand what I am asking

1 response

Hi Ollie,

You could make a list of couponnumbers and their discount amount.
When a customer enters a couponnumber you could use Vlookup to get the discount amount.
Then use a simple calculation function to calculate the price with discount.

If you need a more specified solution then give more details on how your sheet looks like and the different coupons you are using.

Best regards,
Trowa
0