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?
>
Microsoft Office