Hi there, first time poster...
I need help developing a table with 3 columns. The background here is I want to figure out how much someone has to pay by the hour for parking in a garage. The economy area costs $3/hour with a daily maximum of $28, and weekly maximum of $130. The "luxury" area costs $4/hour with a daily maximum of $35 and no weekly ceiling. So the table ultimately would look like:
Column A: hours 1-8760 (hours in a year)
Column B: economy area cost
Column C: luxury area cost
I have tried a bunch of different combinations of calculations and nested if statements but hit a wall every time. I would really appreciate if someone can help me figure this out!
Thanks,
Amy
I need help developing a table with 3 columns. The background here is I want to figure out how much someone has to pay by the hour for parking in a garage. The economy area costs $3/hour with a daily maximum of $28, and weekly maximum of $130. The "luxury" area costs $4/hour with a daily maximum of $35 and no weekly ceiling. So the table ultimately would look like:
Column A: hours 1-8760 (hours in a year)
Column B: economy area cost
Column C: luxury area cost
I have tried a bunch of different combinations of calculations and nested if statements but hit a wall every time. I would really appreciate if someone can help me figure this out!
Thanks,
Amy