Job/Career Article Categories

15 Useful Google Spreadsheet Formulas and Functions You Must Know

List of 15 Useful Google Spreadsheet Formulas and Functions You Must Know

Google spreadsheets are popular online tool for anyone who wants the power of excel on web. Google doc spreadsheet functions and formulas are not known to lots of people. We have a google spreadsheet function list that will help you get flying start on utilizing google docs with spreadsheets.

We live in the century of information: we get it, share it, we breathe it. In such conditions there is a strong requirement to store and transform this info. You can use your note pad to document essential things or your computer system to keep the info here but in any scenario you’ll need something quick and hassle-free.

Here are the most essential factors for working with information:

  • Quick conserving
  • Easy gain access to from anywhere

It’s up to you which program or other means you choose. Personally I used to work in Excel as it has a good system of storing information in different cells as well as good tools to transform and visualize it. The main thing I like about Excel is its

functions and formulas

. However at the exact same time there is one substantial flaw: Excel is a desktop program and you can’t access your files from different computers. That’s where Google Spreadsheets enter into play.

Google Spreadsheets are rather similar to Excel however they are a little much better as they enable you to modify your files online and grant access for seeing and modifying them to other individuals.

What Are Functions And Solutions?

Functions and formulas let you calculate or change data. They increase your efficiency and reduce time invested on modifying information manually
A Google Spreadsheet formula begins with an equivalent sign = and helps to calculate something with the aid of mathematical operators: + is for addition; – is for subtraction; * is for multiplication, / is for department

One formula can contain a function or several functions. These are predefined guidelines that are used to transform cells. =SUM, =LEN are functions.

Arguments show which cell you want to transform. They are contained in parenthesis. For example, =AMOUNT( C5: C67).

Theory is over so let’s practice a little

15 Useful Google Spreadsheets Functions and Formulas

The majority of people utilize Google spreadsheets nevertheless not extremely clear about how to do solutions in google sheets. Below are some heavily used spreadsheet solutions that can help you get going.


Wondering how to sum in google sheets? You can discover amount of vales contained in different cells. To attain that you can utilize the SUM function as seen in the example listed below:

= AMOUNT( B2, B3, B4).

Additionally, you can utilize a formula here: just include a plus indication to arguments

= B2+ B3+ B4.


Need to understand an average quantity of particular cells? Use the matching function for that

= AVERAGE( B2, B3, B4).


If you require quickly equate, utilize this function. It needs to appear like this

A1 is the cell consisting of text you require to translate; en is the source language; ru is the target language

Don’t rely on maker translation all the time, it is far from ideal.


The NOW (previous googleclock) function includes current time and date to your file. The time is upgraded only when you are editing the spreadsheet.

= NOW().

Note that you don’t need any arguments here.


This function is for you if you always forget which date is today like I do. It will help you to learn more about the present date rapidly

= TODAY().

As you can see, the function doesn’t require any arguments simply like the previous one. There are no YESTERDAY or TOMORROW functions so you will have to figure out these dates yourself.


In case you were trying to find the method to import any feed from a URL, look no longer: here it is.



This function will be helpful if you need to change the layout of the details to much better evaluate it

= TRANSPOSE (A1: F15).


You no longer require to capitalize the very first letter of each word manually, simply use this PROPER function

= PROPER( A5).


Need to capitalize all words in a cell? Utilize UPPER function

= UPPER( A1).


Get to understand the characters count of text in any cell by utilizing LEN function. This is really practical if you are composing meta tags or AdWords ads

= LEN( G7).


In case you require to get rid of unneeded spaces between words in a cell, utilize the TRIM function

= TRIM( G6).


To join 2 worths from different cells, you can use this magic function


As displayed in the example, you can sign up with domain names to the rest of URLs. This function conserved me hours of work!


Picture you have lots of cells and a few of them include duplicate values. You need to get only unique worths, so use SPECIAL function

= UNIQUE( A1: Y6).
Note that the arguments here are divided by a colon; this means we utilize a variety here

The example is quite straight-forward however it highlights how the function works. It is comparable to highlighting and getting rid of duplicate values in Excel.


In case you needed to place an image in a cell in Google Spreadsheet, here is the solution

= IMAGE( image URL).


Those who are gotten in touch with email marketing and collecting e-mails, know that sometimes e-mails may be void for some factor (missing @ or dot, for instance). It’s an excellent idea examine your list of e-mail addresses prior to sending your email campaign.

More Job/Career Ideas & Resources

This check returns TRUE/FALSE values you can even more analyze

Things To Keep in mind.

  • All Google Spreadsheet functions and formulas can have either cells numbers you need to transform or just text (or numbers).
    = UPPER( T6).
    = UPPER( text to transform).
  • If you utilize text or URLs in parenthesis, do not forget to use quotation marks
    = IMPORTFEED( feed/).
    = PROPER( words to use).
  • Some solutions need particular arguments divided by commas; others need a series of cells. A range begins from the first cell you need to transform, then goes a colon followed by the last cell in the range. For example
    = CONCATENATE( A1, B1)– these are private cells
    = SPECIAL( A1: Y6) – this is a range of cells.
  • Usage Google Spreadsheet tips that are seen every time you start to get in a formula or function. This implies you do not require to keep in mind all the numerous trivia.A list of formulas and functions you need considerably depends on tasks you have. Experiment a little and you’ll build a powerful tools set. I hope these functions will help you with that!
  • Article source: