A Drop of Excel - 09 | Working with IF Conditions and Conditional Formatting in Excel
Conditions are very important to understand and use in Excel. It has the power to save you hours and hours of time by automating your calculations.
For example, You have to give a value of 0 incentive to any order upto the value of 5,000 and 10% incentive to any order above the value of 5,000.
You have 17,000 orders data. It would take you a very long time to do this manually. Even if you use sort and filter, it will take longer and also for any new orders coming in, the process will need to be repeated.
Using IF condition simplifies this.
Conditional formatting on the other hand can highlight all orders where the incentive is greater than 10,000. This will give you a quick visual indication of higher incentive values. This also if you do it manually, can take a very long time to complete.
Example file link
https://drive.google.com/file/d/108e7...
\ Previous video: • A Drop of Excel - 08 | Restrict and P...
/ Understanding of the data being used in the examples: • A Drop of Excel | Understanding the d...
Related Videos/Posts
18 Most Useful Excel shortcuts -- • 18 Most Useful Excel Shortcuts
IF vs IFS function in Excel 2016 -- • IF versus IFS function in Excel 2016
