Excel formulas and how to use them

1. SUM: The SUM formula is used to add up a range of numbers in Excel. To use it, simply type "=SUM(" in a cell, and then select the range of numbers you want to add up. For example, if you want to add up the numbers in cells A1 to A10, you would type "=SUM(A1:A10)".

2. AVERAGE: The AVERAGE formula is used to calculate the average of a range of numbers in Excel. To use it, simply type "=AVERAGE(" in a cell, and then select the range of numbers you want to calculate the average for. For example, if you want to calculate the average of the numbers in cells A1 to A10, you would type "=AVERAGE(A1:A10)".

3. MAX: The MAX formula is used to find the highest value in a range of numbers in Excel. To use it, simply type "=MAX(" in a cell, and then select the range of numbers you want to find the highest value for. For example, if you want to find the highest value in cells A1 to A10, you would type "=MAX(A1:A10)".

4. MIN: The MIN formula is used to find the lowest value in a range of numbers in Excel. To use it, simply type "=MIN(" in a cell, and then select the range of numbers you want to find the lowest value for. For example, if you want to find the lowest value in cells A1 to A10, you would type "=MIN(A1:A10)".

5. IF: The IF formula is used to perform a conditional operation in Excel. It allows you to test a condition, and then perform one operation if the condition is true, and another operation if the condition is false. To use it, type "=IF(" in a cell, and then enter the condition you want to test, followed by the operation to perform if the condition is true, and the operation to perform if the condition is false. For example, if you want to test if the value in cell A1 is greater than 10, and then return "Yes" if it is, and "No" if it isn't, you would type "=IF(A1>10,"Yes","No")".