I want to get a result of "Ready for QA" for a few conditions being true. Here are the IF statements that I wrote for each condition, but I don't know how to combine them. If all of these conditions are true, I want to populate the column with the words "Ready for QA"
IF({name}="Upload instructor materials"&&{percentComplete}<100
IF({name}="Upload participant materials"&&{percentComplete}<100
IF({name}="Set up Conferences i/o session (settings, polling)"&&{percentComplete}<100