Forum Discussion
Need Assitance With Formula
Hi I have an Excel table that tracks projects. The columns in the table are name of project, team mate assigned, status, and due date. I would like to create an if statement function that would be ba...
Depends on how many statuses you have. In simplest case in Status column it could be
=IF( (DueDate - TODAY() <=3)*(DueDate.TODAY() ), "High priority", "Nothing critical" )It's better if you give more details how the data is structured on on which Excel platform/version you are.