Applying multiple IF functions to every row <p>I need to apply the following IF functions to every row in columns J, L, and S so that the correct date value is printed in the corresponding cell in row T. For example, cell T2 will have a date printed in it based on the outcome of running these IF functions on J2, L2, and S2; cell T3 will have a date printed in it based on the outcome of running these IF functions on J3, L3, and S3; and so on. Here's what I have got:</p> <pre><code>Sub Test1() Set firstDate = Range("S2") If Range("J2") = "GS/CA/SL/GW" Then If Range("L2") = "1" Or "2" Or "3" Then Range("T2") = DateAdd("ww", 52, firstDate) End If If Range("L2") = "4" Or "5" Or "6" Then Range("T2") = DateAdd("ww", 104, firstDate) End If If Range("L2") = "7" Or "8" Or "9" Then Range("T2") = DateAdd("ww", 156, firstDate) End If End If End Sub </code></pre> <p>It works on one set of cells at a time if I just redefine all the ranges, but I thought there must be an easier way than pasting and editing the code ~3500 times for all the rows I have to run it on. Any help would be appreciated! </p>