AlexCertificati
6 years agoQrew Cadet
Re: IF AND Formula Issue
You might actually be better off with a Min, anyway; it looks like you want to do $25/day for up to 7 days?
I'd write that
Min(ToDays([Hotel Check-Out Date]-[Hotel Check-In Date]),7)*25
though admittedly I don't understand what your last clause is doing (and my Min formula omits it); the concept is length of stay times $25, up to $175, unless the length of stay is less than 7 days and in the future, in which case it's $7?
I also notice now that your formula as written now is returning a null value if length of stay is greater than 7 and the checkin date is in the past. You've got me curious.
I'd write that
Min(ToDays([Hotel Check-Out Date]-[Hotel Check-In Date]),7)*25
though admittedly I don't understand what your last clause is doing (and my Min formula omits it); the concept is length of stay times $25, up to $175, unless the length of stay is less than 7 days and in the future, in which case it's $7?
I also notice now that your formula as written now is returning a null value if length of stay is greater than 7 and the checkin date is in the past. You've got me curious.