The following code checks if the value in J$12($ex: $700)$ is less than $500.$ Since it is not, S$2$ is populated in J$18$ and $180$ is divided by the value in J$14($ex: $355/180=2).$ Edit the code to implement the following.

If cs$.$Range$("$J$6")="$DC$"$ Then

If cs$.$Range$("$J$12")<500$ Then

cs$.$Range$("$J$18")="$S$1"$

cs$.$Range$("$J$20")=$ Application.WorksheetFunction.Ceiling$($cs$.$Range$("$J$14")/360,1)$

Else

cs$.$Range$("$J$18")="$S$2"$

cs$.$Range$("$J$20")=$ Application.WorksheetFunction.Ceiling$($cs$.$Range$("$J$14")/180,1)$

End If

Edit the code to implement the following

For S$1$:

If DC is selected in J$6,$ Then if value entered in J$12$ is $0-330$ divide J$14$ by $360.$

If DC is selected in J$6,$ Then If value entered J$12$ is $331-500$ and divide J$14$ by $240.$

For S$2$:

If DC is selected in J$6,$ Then if value entered in J$12$ is $500-660$ divide J$14$ by $180.$

If DC is selected in J$6,$ Then If value entered J$12$ is $661-1000$ and divide J$14$ by $120.$