All articles with 'conditional formatting' Tag

You want to check two conditions with Excel IF function? You’ve come to the right place. IF is one of Excel’s most popular and versatile functions. But things get exciting when you start combining it with multiple conditions — especially using AND, OR, nested IFs, and even blending it with SUMIFS. In this article, let […]

Do you know that we can easily calculate the critical path for a project using Excel formulas?

For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.

Put on your hardhats, this one is going to blow your minds.