This article provides a consolidated view of the frequently used formulas in Excel.
Concatenate means linking or combining things together. This formula combines contents two or more different cells in a single cell.
Formula: = CONCATENATE(text1, [text2], …)
Here comma is the separator between string that will be joined.
Click on link below for the complete post :
concatenate-function-in-excel/
The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.
Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)
Click on link below for the complete post :
The count formula counts the number of cells in a range that have numbers in them.
Formula: =COUNT(A1:A10)
Click on link below for the complete post :
count-countif-and-countifs-in-excel/
Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them.
Formula: =COUNTA(A1:A10)
Click on link below for the complete post :
The LEN formula finds the length of cell’s content by counting the number of characters in the cell.
Formula: =LEN(A1)
Click on link below for the complete post :
TRIM formula gets rid of unwanted extra space in a cell, except for single spaces between words.
Formula: =TRIM(A1)
Click on link below for the complete post :
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Formula: =MATCH(lookup_value, lookup_array, [match_type])
Click on link below for the complete post :
Use this formula, when you need to find things in a table or a range by row.
For example, look up an employee’s last name by her employee number, or find her phone number by looking up her last name (just like a telephone book).
Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Click on link below for the complete post :
Use IF statement, when you want to have different behaviors depending on a condition.
Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
Click on link below for the complete post :
These formulas all do their respective functions (SUM, COUNT, AVERAGE) IF the criteria are met.
Formulas:
=SUMIF(range, criteria, sum_range)
=COUNTIF(range, criteria)
=AVERAGEIF(range, criteria, average_range)
Click on link below for the complete post :
count-countif-and-countifs-in-excel/
If you are looking for a reference to all excel functions, then this post would be of help :
© 2015 – 2023, https:. All rights reserved. On republishing this post, you must provide link to original post