How To Use Excel Functions

Click on the formulas tab.

How to use excel functions. 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. Being primarily designed as a spreadsheet program microsoft excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. The if function runs a logical test and returns one value for a true result and another for a false result. For example if the range a1 a3 contains the values 5 7 and 38 then the formula match 7 a1 a3 0 returns the number 2 because 7 is the second item in the range. The action to perform if the condition is met or is true.

Cell references in excel are very important. That s why we ve put together this beginner s guide to getting started with excel. The most used functions in excel are the functions that count and sum. The if function can be combined with logical functions like and and or to extend the logical test. 1 count and sum.

You can count and sum based on one criteria or multiple criteria. The action to perform if the condition is not met or is false. For example to pass scores above 70. Please follow the below steps. The tutorial explains the syntax of the excel find and search functions and provides formula examples of advanced non trivial uses.

This is the condition for the function to check. Understand the difference between relative absolute and mixed reference and you are on your way to success. More than one condition can be tested by nesting if functions. In the last article we covered the basics of the excel find and replace dialog. A beginner s guide to getting started.

The tutorial provides a list of excel basic formulas and functions with examples and links to related in depth tutorials. It is a worksheet function in excel. Written by co founder kasper langmann microsoft office specialist. Learn how to use excel s logical functions such as if and or and not. In many situations however you may want excel to find and extract data from other cells automatically based on your criteria.