Introduction:
some useful formula tips for microsoft excel
SUM Formula:
Use the SUM formula to add up a range of cells. For example, =SUM(A1:A10) will add up the values in cells A1 through A10.
AVERAGE Formula:
Use the AVERAGE formula to find the average of a range of cells. For example, =AVERAGE(A1:A10) will find the average of the values in cells A1 through A10.
COUNT Formula:
Use the COUNT formula to count the number of cells in a range that contain numerical data. For example, =COUNT(A1:A10) will count the number of cells in cells A1 through A10 that contain numerical data.
IF Formula:
Use the IF formula to create conditional statements. For example, =IF(A1>B1,"Yes","No") will return "Yes" if the value in cell A1 is greater than the value in cell B1, and "No" otherwise.
CONCATENATE Formula:
Use the CONCATENATE formula to combine text from multiple cells into a single cell. For example, =CONCATENATE(A1," ",B1) will combine the text from cells A1 and B1, separated by a space.
VLOOKUP Formula:
Use the VLOOKUP formula to search for a value in a table and return a corresponding value from another column in the same row. For example, =VLOOKUP(A1,B1:C10,2,FALSE) will search for the value in cell A1 in column B of the table B1:C10, and return the corresponding value from column C.
HLOOKUP Formula:
Use the HLOOKUP formula to search for a value in a table and return a corresponding value from another row in the same column. For example, =HLOOKUP(A1,A1:C10,2,FALSE) will search for the value in cell A1 in row 1 of the table A1:C10, and return the corresponding value from row 2.
MAX and MIN Formulas:
Use the MAX and MIN formulas to find the largest and smallest values in a range of cells, respectively. For example, =MAX(A1:A10) will find the largest value in cells A1 through A10, while =MIN(A1:A10) will find the smallest value.
ROUND Formula:
Use the ROUND formula to round a number to a specified number of decimal places. For example, =ROUND(A1,2) will round the value in cell A1 to two decimal places.
TODAY Formula:
Use the TODAY formula to insert the current date into a cell. For example, =TODAY() will insert today's date into the cell.