Needing Help with an IF TODAY formula

Lindsey Iversen

After reading countless articles and trying countless combos, I still can't get this formula to work. I am trying to give a 30 day notice to an expiration day with a status column.

=IF([TIPS Expiration]-TODAY()>30,"Green", IF[TIPS Expiration]-TODAY()<30,"Yellow"))

Paul Newcome

You are missing an opening quote after the second IF.