Maintaining spreadsheets is not the easiest or most effective method for managing a project. Still, should you find yourself relying on a workbook to track assigned tasks and overall team performance, it's important to learn how to do if then statements in Excel.