nesting formula
1 TopicI have a nesting formula I am trying to restrict the out put by todays date -7
=IF(E2=1, "letter 2", IF(E2=2,"letter 3", IF(E2=3, "call", "nothing issued"))) The above gives me the correct output necessary for determining which letter I next need to issue, however, I would like to be able to limit the output by cell E3 which contains the date; therefore, I am looking to only produce the above IF outcome if the date in E3 is 7 days prior to today. Your assistance is greatly appreciated.964Views0likes1Comment