The IF function adds flexibility to Google Spreadsheets by introducing decision making.
What the function does is test one or more specific conditions that you set to see if they are true or false.
If a condition is true, the function will carry out one action. If a condition is false, it will carry out a different action.
These actions can include executing a formula, inserting a text statement, displaying number data, or leaving the target cell blank.
To find out more about how this function works, read this tutorial on the Google Spreadsheets IF Function.Related Tutorials
A function is just a set formula that has been added to the program to simplify an operation, and, as long as your data is laid out in a regular pattern, the SUM function can make the task of adding up those columns or rows much easier.
To learn more, read this short tutorial on how to use the SUM Function in Google Spreadsheets.Related Tutorials
There is a group of functions in Google Spreadsheets called the Count Functions.
For one of these - the COUNT function - the job is to only add up those cells that contain numbers.
This function ignores empty cells or those containing text. So if you need to know how many cells contain numbers or dates in a spreadsheet the COUNT function will do the job for you.
To find out the details about using this function, read the tutorial on the Google Spreadsheets COUNT Function.Other Google Spreadsheets Count Functions
For most of us, subtracting two numbers is not a difficult task. If, however, you are trying to do it for the first time in a spreadsheet program like Google Spreadsheets the task may seem next to impossible.
To get Google Spreadsheets to subtract numbers, or to carry out any other mathematical operation, you have to tell it what you want it to do using the correct instructions in the correct order.
These instructions are contained in a formula. The formula tells the program what data to use, the mathematical operation(s) to carry out, such as subtraction, and where the answer should be displayed.
This may sound rather complicated but it isn't really. To find out how easy it is, read the short tutorial on How to Subtract in Google Spreadsheets. This tutorial has links to other basic operations, such as addition, division, and multiplication.Related Tutorials
To find out just how easy it is, read this short tutorial on how to Navigate Using the Name Box in Excel .Related Tutorials
A hyperlink - the blue text in a web page that links to other web pages and documents - also provides quick and easy access between Excel workbooks.
Similarly, a bookmark can be used to create a link to a specific area in the current worksheet or to different worksheets within the same file.
Both make it easier for users to navigate between areas of related data and both are easy to insert and use in Excel.
To find out just how easy, read this short tutorial on how to Add Hyperlinks and Bookmarks in Excel .Related Tutorials
Excel has a number of database functions such as DSUM.
Only those records that match the set criteria are included in the calculations performed by the function.
Once the data has been filtered, DSUM will return the total for a column of data chosen by the user.
To find out all the details, read this tutorial on the Excel DSUM function.
There are two forms for the LOOKUP function in Excel - the Vector Form and the Array Form.
The difference between the two lies in where the function will look to retrieve data.
The vector form will only look in a single row or column while the array form will return data from the last row or column from a block of data called, not surprisingly, an array.
To find out more about using the array form of this function, read this tutorial on the Excel Lookup Function - Array Form.
This function is not as specialized as the other lookup functions so it can be used to find a single field of data located in either a column or row of a data table.
Further, this function has to forms - the Vector and Array forms.
The vector form lets you specify single rows or columns to search for the desired information, while the array form can be used to search large blocks of data.
To find out more about using the vector form of this function, read this tutorial on the Excel Lookup Function - Vector Form.
Another of Excel's lookup and reference functions is the COLUMN function.
This function can be used in two ways.
One, it can be used to return the number of the column for the cell where the function is located in the worksheet.
Two, it can be used to return the number for a column of a given cell reference.
The COLUMN function is often combined with other functions, such as the VLOOKUP, to create versatile lookup formulas.
To find out all the details on how this function works, read this short tutorial on the Excel COLUMN Function.