The AND remix for the popular IF function can save at least 180 seconds of your time. 

This Excel Q&A by Philip Gamey will show you how to create one IF statement that checks for two conditions before returning a result.