15 Basic Microsoft excel formulas list with examples. This is the first Excel Function one should be familiar with. Data for Excel formula list in this guide.
Searches a range or an array and returns an item corresponding to the first match it finds.
Use dollar signs to keep one cells formula the same regardless of where it moves. When you select a cell Excel shows the value or formula of the cell in the formula bar. Understanding formula basics. This Excel Basic function is used to count the blank value in the Range.