Hi all!
So, I'm both an idiot in regards to Excel and Forum posting (as this is my first foray in the latter).
Basically, what I'm trying to do is this:
If a hotel has multiple "Seasons" (example: high, low, shoulder) in any given year, this affects pricing. I have already run a master template to calculate the double occupancy price based on the season and the room type chosen.
HOWEVER, there are additional fees for extra adults...and of course the fees vary depending on BOTH the season and the room type. I tried the below formula...presuming A1 is room type, B1 is Season, and C1 is number of adults (with base of 2 per room)...
=IFS(B1="Low2018",A1="Resort",C1="3",94)
Basically, I'm trying to say, the Resort room, in Low Season for 2018, with 3 adults, incurs an additional $94 charge. (I've already calculated the double occupancy, remember, so I'm just trying to add this in as a separate column).
But nothing is working. If the formula doesn't return an error, it also doesn't return the $94 addition I'm looking for...
Like I said, I'm an idiot. And I'm grateful for anyone who can help me out here!
So, I'm both an idiot in regards to Excel and Forum posting (as this is my first foray in the latter).
Basically, what I'm trying to do is this:
If a hotel has multiple "Seasons" (example: high, low, shoulder) in any given year, this affects pricing. I have already run a master template to calculate the double occupancy price based on the season and the room type chosen.
HOWEVER, there are additional fees for extra adults...and of course the fees vary depending on BOTH the season and the room type. I tried the below formula...presuming A1 is room type, B1 is Season, and C1 is number of adults (with base of 2 per room)...
=IFS(B1="Low2018",A1="Resort",C1="3",94)
Basically, I'm trying to say, the Resort room, in Low Season for 2018, with 3 adults, incurs an additional $94 charge. (I've already calculated the double occupancy, remember, so I'm just trying to add this in as a separate column).
But nothing is working. If the formula doesn't return an error, it also doesn't return the $94 addition I'm looking for...
Like I said, I'm an idiot. And I'm grateful for anyone who can help me out here!