Microsoft Excel provides additional functions that can be used to analyze your data based on a condition. For example, to count the number of occurrences of a string of text or a number within a range of cells, use the COUNTIF function. To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF function.
Assignment on commonly used formulas for MS Excel
![Assignment on commonly used formulas for MS Excel](https://assignmentpoint.com/wp-content/uploads/2012/05/Examples-of-commonly-used-formulas-for-MS-Excel.jpg)