Forum Discussion
Return different values depending on multiple conditions
Hi I wonder if there's someone out there who can help. I've got a set of dates in column C and a set of values 1-12 in column E. I need column L to return dates as follows: For L2: C2+180 if ...
In L2:
=IF(OR(C2=0, E2=0), "", C2+IFS(E2>11, 30, E2>7, 60, E2>3, 90, E2>0, 180))
Format L2 as a date, then fill down.
Ah, IFS! Works a treat. Thank you!
