How To Use Excel Functions

For a list of available functions click a cell and press shift f3 which will launch the insert function dialog.

How to use excel functions. Cell references in excel are very important. Understand the difference between relative absolute and mixed reference and you are on your way to success. 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. Learn how to use excel s logical functions such as if and or and not. Arguments can be numbers text logical values such as true or false arrays error values such as n a or cell references.

A beginner s guide to getting started. In the last article we covered the basics of the excel find and replace dialog. Vlookup is another lookup function you can use in excel but unlike match which requires index for advanced lookups vlookup formulas only need that one function. The tutorial explains the syntax of the excel find and search functions and provides formula examples of advanced non trivial uses. For example to pass scores above 70.

1 count and sum. It will take you from the very beginning opening a spreadsheet through entering and working with data. In many situations however you may want excel to find and extract data from other cells automatically based on your criteria. The action to perform if the condition is not met or is false. The most used functions in excel are the functions that count and sum.

If logical test value if true value if false logical test. You can count and sum based on one criteria or multiple criteria. Please follow the below steps. The tutorial provides a list of excel basic formulas and functions with examples and links to related in depth tutorials. The action to perform if the condition is met or is true.

More than one condition can be tested by nesting if functions. It found under the formulas tab. 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. Written by co founder kasper langmann microsoft office specialist. As a worksheet function the code function can be used as part of a formula.