top of page
  • Excel Master

What Are The 10 Basic Excel Formulas?

Here are ten basic Excel formulas:

  1. SUM: This formula adds up a range of cells. For example, =SUM(A1:A10) adds up the values in cells A1 through A10.

  2. AVERAGE: This formula calculates the average of a range of cells. For example, =AVERAGE(A1:A10) calculates the average of the values in cells A1 through A10.

  3. COUNT: This formula counts the number of cells in a range that contain numeric values. For example, =COUNT(A1:A10) counts the number of cells in cells A1 through A10 that contain numbers.

  4. MIN: This formula finds the smallest value in a range of cells. For example, =MIN(A1:A10) finds the smallest value in cells A1 through A10.

  5. MAX: This formula finds the largest value in a range of cells. For example, =MAX(A1:A10) finds the largest value in cells A1 through A10.

  6. IF: This formula performs a logical test and returns one value if the test is true and another value if the test is false. For example, =IF(A1>10,"Yes","No") tests if the value in cell A1 is greater than 10, and returns "Yes" if it is true and "No" if it is false.

  7. CONCATENATE: This formula joins two or more text strings together. For example, =CONCATENATE("John"," ","Doe") joins the text strings "John", " ", and "Doe" to form "John Doe".

  8. LEFT: This formula returns a specified number of characters from the beginning of a text string. For example, =LEFT(A1,3) returns the first three characters of the text string in cell A1.

  9. RIGHT: This formula returns a specified number of characters from the end of a text string. For example, =RIGHT(A1,3) returns the last three characters of the text string in cell A1.

  10. VLOOKUP: This formula searches for a value in the first column of a table and returns a corresponding value in a specified column. For example, =VLOOKUP(A1,Table1,2,FALSE) searches for the value in cell A1 in the first column of Table1, and returns the corresponding value in the second column of Table1.

4 views0 comments

Recent Posts

See All

How to Use the Autofit Column Width Shortcut in Excel

To use the Autofit Column Width shortcut in Excel, follow these steps: Open Microsoft Excel and navigate to the worksheet containing the columns you want to autofit. Select the column or columns that

How to Add Axis Labels in Excel

To add axis labels in Excel, follow these steps: Open Microsoft Excel and open the worksheet containing the chart you want to edit. Click on the chart to select it. This will activate the Chart Tools

Comments


bottom of page