formula if then - output number of days

WinaHath

If Written Notice Due (Days) = 30, then Advance Notification days = 90; if 60 then 120, if 90 then 150, if 120 then 240

I will enter the data on Written Notice Due Days column (30/60/90/120) and I need a formula to output to Advance Notifications.

markkrebs

=IF([Written Notice Due (Days)]@row = 30, 90, IF([Written Notice Due (Days)]@row = 60, 120, IF([Written Notice Due (Days)]@row = 90, 150, IF([Written Notice Due (Days)]@row = 120, 240))))

markkrebs

=IF([Written Notice Due (Days)]@row = 30, 90, IF([Written Notice Due (Days)]@row = 60, 120, IF([Written Notice Due (Days)]@row = 90, 150, IF([Written Notice Due (Days)]@row = 120, 240))))

WinaHath

THANK YOU SOOOO MUCH!!! 😁