Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. Check out this video about using VLOOKUP. 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). Use this function when you need to find things in a table or a range by row. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column. Here's a video about using the IF function. Use this function to return one value if a condition is true and another value if it's false. Use this function to add the values in cells. Utilize Autofill to apply the formulae on each cell.Here are the 10 functions that people read about most.To add text from multiple cells utilizing the “&” operator, we just have to put the cell references and place the operator in between.The Ampersand operator is also a useful operator that we can utilize to add text from multiple cells in Microsoft Excel. Utilize Autofill to apply the function on each cell.įormula 5: Utilizing the Ampersand Operator.Step 2 – Utilize Autofill to Apply the Function on Each Cell The cell A2 and B2 contain the designation and the name of the employee respectively.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |