I am trying to use the IF function on Multiple senerios.
Days to depart between greater than = to 1 and less than = to 30 then 1-30 and repeat this for days upto 180 and then over 180
1-30, 31-60, 61-90, 91-120, 121-150, 151-180, 181+
Can anyone suggest a formula to use.
This has been puzzling me for a while now.