Month: December 2016

Google Sheets Functions – HYPERLINK

Here let’s take a quick look at the HYPERLINK function, which allows you to add hyperlinks with ease and to also rename them. Here I’ve just copied and pasted my blog address into the cell. This is fine, but sometimes we don’t want an ugly URL in our sheet. For example, I can change what shows by using the HYPERLINK function. Here I add the URL between speech marks, then after the comma add the text I want visible on the sheet, again in speech marks. Now in cell A3, I have the text I want. When you hover over the text, you can see that it’s linked to a URL and clicking on the blue link, will take you to the webpage. Extra tip: Links to documents on your Drive could also be done in this way. Just make sure the person using your sheet, has access to the document. eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions: “Beginner’s Guide to Google Drive” – iBooks store / Kindle store “Beginner’s Guide to Google Forms” - iBooks store / Kindle store "Beginner's Guide to Google Sheets" - iBooks store / Kindle store "Beginner's Guide to Google Docs" - iBooks Store / Kindle store "Beginner's Guide to Google Slides" - iBooks Store / Kindle store "Google Sheet Functions - A step-by-step guide" - iBooks Store / Kindle Store Baz Roberts (Google+...

Read More

Google Sheets Functions – ROUND, ROUNDUP, ROUNDDOWN

In this post we’re going to have a quick look at rounding numbers up and down, by using the ROUND, ROUNDUP, and ROUNDDOWN functions. The syntax is very easy, we tell the function the number we want to round and then to how many decimal places. In cell A1 we have a number and in B2 we want to reduce it to just 2 decimal places. In cell B2 we write =ROUND(A1,2), this gets the number in cell A1 and then converts it to 2 decimal places. In the examples below we can see how the same formula treats numbers that are 0.5 or higher or less than 0.5. If the number is half or more it will round the number up, so 3.56 becomes 3.6, if we’re working to 1 decimal place. If the number is less than half, it will round it down, so 3.14 becomes 3.1. We can control whether we want it to round up or down. To always round it up, we use the ROUNDUP function in the same way as before. As you can see, it’s rounded both figures up this time. To always round down, we use the ROUNDDOWN function in the same way: If you want to round whole numbers up, for example, to the nearest thousand, use a negative number. Here I’m rounding to the nearest thousand, by adding a -3....

Read More

Google Sheets Functions – IMAGE

In this post let’s look how we can insert images into our sheets. There are two main ways, either inserting the image via the Insert menu or by using the IMAGE function. Example 1 – Inserting an image from Drive Here let’s add an image from my Drive. Open the “Insert” menu then click “Image”. Choose where your image is, in this case, let’s choose “Google Drive”. Search for your image, and click on the one you want, then click Select. This will place the image on top of your sheet and won’t affect the cells in any way. You can change the size of it by moving the blue squares on the border of your image. Example 2 – Inserting an image within a cell using the IMAGE function An alternative way to inserting images, is to use the IMAGE function, which will insert the image within the cell where that function is. To do this we need the URL of the image. In the cell I type =IMAGE() then in between the brackets I add speech marks and the URL inside them, i.e. =IMAGE(“”) Here I’ll add an image from my blog: This adds the image within the cell. A bit small isn’t it? This is because it has adjusted the size of the image to the size of cell. To make it bigger we just make...

Read More


eBooks available

Pin It on Pinterest