Hi All,

I don't use excel all the time and need help with creating an IF Statement for our gift program. The condition is years of service less than 15 I want the cell to read "no tray". I can get that part to work but not when there is a blank cell. I need the cell to stay blank.

This formula works and no tray appears when the service is less than 15, but it is saying no tray when the cell is blank which I don't want.

Thanks for helping me!

=IF(Table7[[#This Row],[Years of Service]]<15, "No Tray", "")