One of the first youtube videos I was actually excitedly waiting for! Been very grateful for this tutorial, my skills have improved in such a short period of time.
Allow me to oblige: logical test 1 value if true 1 logical test 2 value if true 2 logical test 3 value if true 3...and so on =IFS(F5=1,"Soup",F5=2,"Sub",F5=3,"Salad")