Excel formulas available for various purposes. Here are a few commonly used formulas along with examples: 1. SUM: Calculates the sum of a range of cells. Example: If you have a list of numbers in cells A1 to A5 (e.g., 5, 10, 15, 20, 25), you can use the SUM formula to calculate their sum. In an empty cell, enter "=SUM(A1:A5)" (without quotes), and press Enter. The result will be the sum of the numbers, which in this case is 75. 2. AVERAGE: Calculates the average of a range of cells. Example: Suppose you have a range of numbers in cells A1 to A5 (e.g., 10, 20, 30, 40, 50). To find their average, enter "=AVERAGE(A1:A5)" (without quotes) in an empty cell, and press Enter. The result will be the average of the numbers, which is 30 in this case. 3. MAX: Returns the highest value in a range of cells. Example: If you have a list of numbers in cells A1 to A5 (e.g., 5, 10, 15, 20, 25), you can use the MAX formula to find the highest value. Enter "=MAX(A1:A5)" (...
Comments
Post a Comment