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
drive.google.com/file/d/108e7...
\ Previous video: • A Drop of Excel - 08 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
- 18 Most Useful Excel shortcuts -- • 18 Most Useful Excel S...
- IF vs IFS function in Excel 2016 -- • IF versus IFS function...