Hello and thank you in advance for taking a look at my question!
I would like to have a formula that analyzes two columns of data to return a specific amount, or 0.
Column 1: # Nights
Column 2: Cabin Name
If # Nights is greater than or equal to 7, AND Cabin Name is “299” then $1800, if not then $0
If # Nights is greater than or equal to 7, AND Cabin Name is “514” then $1850, if not then $0
I am struggling with the logic of whether the IF statement for cabin name comes first or the # of nights comes first. Also struggling with the IF(AND…) formula - or perhaps I should be using a different formula altogether?