IF function help with multiple senarios


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.


By: Diane

Leave a Reply

Your email address will not be published. Required fields are marked *