Hello,
I'm new to this forum so sorry for any faux pas.
I'm trying to write a formula that calculates nightly rental rates of hotel rooms based on Unit, Season, and number of nights.
Unit A in High Season for 1-6 nights has a rate of $145 per night
Unit A in High Season for 7+ nights has a rate of $142.50 per night
Unit A in Low Season for 1-6 nights has a rate of $130 per night
Unit A in Low Season for 7+ nights has a rate of $120 per night
Unit B in High Season for 1-6 nights has a rate of $320 per night
Unit B in High Season for 7+ nights has a rate of $297 per night
Unit B in Low Season for 1-6 nights has a rate of $288 per night
Unit B in Low Season for 7+ nights has a rate of $274 per night
Unit C in High Season for 1-6 nights has a rate of $400 per night
Unit C in High Season for 7+ nights has a rate of $377 per night
Unit C in Low Season for 1-6 nights has a rate of $360 per night
Unit C in Low Season for 7+ nights has a rate of $354 per night
I'd like to be able to pick the the Unit from a drop-down list, the season from a drop-down list, and then type in the number of nights and return the nightly rate and total rental for nights entered under those circumstances. Is this possible? I've experimented with IF and AND statements but can't seem to figure out how to tie in all variables. I know how to create the drop-down lists.
Bookmarks