Calculating the min and maxwith different percentages

[shaddowflyer]

Iam doing a assignment and iam a bit stuck. now below this paragraph are the numbers of the part in the assignment that iam working with. we have to calculate all sorts of data to calculate the cost of travel for individual people. now in the bit below there are people that are members witch get discounts and some that dont. each hotel gives a different percentage of discount for members. now i need to get the MIN and MAX of what they would have to pay (the travelers). also want to mention that it hasent been decided with hotel each person goes to (that's why using the MIN and MAX to what they would have to pay an the trip). I can do it with taking the whole thing apart and and using a very long string of formula and/or using additional fields but i wonder if there are easier ways using field names and formulas to simplify this. Iam using the IF formula to start with to determin witch person getsthe MIN and Max for non member or member rates.


Hotel Standard Rate Per person discount
Holiday Inn $100 5.00%
Hynatt $120 15.00%
Ramada Inn $115 10.00%
Sheraton $95 N/A
Marriott $100 20.00%
Hilton $80 N/A
Western $75 5.00%

Thaks you for any help

[Ron Coderre]

Since this is an assignment/homework, can you post the formula(s) you tried? Maybe we can get you headed in the right direction.