If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Make a postage calculator
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? |
#2
|
|||
|
|||
Make a postage calculator
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) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Littlefeather" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|