Make a postage calculator

  • Thread starter Thread starter Littlefeather
  • Start date Start date
L

Littlefeather

I want to create a form for a web page. When customers place a 4 digit number
in a box - the adjoing box will give them a response based on their input.
Example: Customer enters (first box either or choice) 1 or 2 items.
second box - post code (4 digits) customer enters 4 digits
Third box - shows $ amt based on customer choices of first two boxes.

I can not find this calc anywhere!!

Can you help?
 
Take a look at the LOOKUP and VLOOKUP functions. You'll need to create a
table correlating post codes with prices. Assuming 2 items cost twice as much
as one item, the formula then becomes something like:

=Cell1 * VLOOKUP(Cell2,YourTable,2,FALSE)
 
Back
Top