1. Technology
Send to a Friend via Email
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Ted's Spreadsheets Blog


Follow me on:

Google Spreadsheets IF Function

Sunday June 1, 2014
Google Spreadsheets IF Function
Google Spreadsheets IF Function
Ted French

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

Quickly Add Numbers in Google Spreadsheets

Wednesday May 28, 2014

One of the most common calculations performed in spreadsheet programs is summing columns or rows of data.

It is carried out so often, that Google Spreadsheets, like Excel and other spreadsheet programs, has a built in SUM function to simplify the operation.

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

Counting in Google Spreadsheets

Monday May 26, 2014

There is a group of functions in Google Spreadsheets called the Count Functions.

In general, this group is used to total the number of cells in a selected range. Each function in the group, however, does a slightly different job.

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

How to Subtract in Google Spreadsheets

Saturday May 24, 2014

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

Moving Around in Excel

Thursday May 22, 2014

If you want to jump to a distant part of a worksheet without having to go through the steps needed to create bookmarks you can always use the Name Box to move to a specific cell in the worksheet.

To find out just how easy it is, read this short tutorial on how to Navigate Using the Name Box in Excel .

Related Tutorials

Add Hyperlinks and Bookmarks in Excel

Monday May 19, 2014

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 DSUM Function

Friday May 16, 2014

Excel has a number of database functions such as DSUM.

How DSUM differs from the regular SUM function is that DSUM lets you specify one or more criteria which act as data filters .

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.

Related Tutorials

Excel Lookup Function - Array Form

Wednesday May 14, 2014

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.

Related Tutorials

Excel Lookup Function - Vector Form

Monday May 12, 2014

There are a number of lookup functions in Excel such as VLOOKUP and HLOOKUP but there is also a LOOKUP function.

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.

Related Tutorials

Excel COLUMN Function

Thursday May 8, 2014

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.

Related Tutorials

©2014 About.com. All rights reserved.