Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP question concerning population a price
If I had a seat list and price list according to age;
Lets say 18 and over is $30.00 and under 18 is $20.00 that is for a floor level seat. A balcony seat is $15.00 if you are 18 and over. It is $10.00 if you are under 18. Then you have a front row seat that is $40.00 dollars if you are 18 and over and $35.00 if you are under 18. I have to determine the price according to age and seat selection. Any help is sure appreciated I am missing some step but can not figure out where. I hope I have given enough information. If not let me know...THANKS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max Price and Min Price paid for an item - Rephrsed | Excel Worksheet Functions | |||
Question on how to raise a price 15% in a coloum | Excel Discussion (Misc queries) | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) |