I need to make an order form

 Trowa -

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 reply

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,