|2:5 is not a syntax that Excel can recognize.|
You have a few choices.
If your criteria is fairly simple, e.g. only the integers 1 - 5 will ever appear in I4, then your criteria is actually 1 or not 1:
=IF(I4=1, F4+30, F4+60)
If you really need to check for the specific values, then try this:
=IF(I4=1, F4+30, IF(OR(I4=2, I4=3, I4=4, I4=5), F4+60, ""))
This might even work for you...
=IF(I4=1, F4+30, IF(AND(I4>1, I4<6), F4+60, ""))
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.