All posts tagged with "Google sheets"

This post describes how to make a checkbox in Google sheets. All of the examples can be found in a sheet here. The easiest way is »

In Google sheets you can use VLOOKUP to look up a value based on a key. In short VLOOKUP will search for a specific key in »

In Google sheets you can use sumif to conditionally sum values in a range depending on a criteria. For example the following formula will sum numbers »

In Google sheets you can use countif to conditionally count cells in a range. For example the following formula will count numbers larger than zero in »

The basic structure of the IF THEN ELSE formula in Google sheets is an IF formula with parameters, it looks like the following: =IF(logical_expression; »

You can easily create in-cell drop-downs in Google sheets using the "Data validation" menu point. It can be found under: * Data * Data Validation Located »

You can reference a cell in Google Sheets by using its location, for example A1, B4 or C2. The location is the combination of the Column »

You can easily fetch tables from websites in your Google sheets. To do this you can use the IMPORTTABLE function, which has the following signature: IMPORTHTML( »

You can easily get a stock price in Google sheets using the GOOGLFINANCE function. A simple example would be if you want the current price of »

There is no straightforward formula to get the percentage change for a stock X days back in time. However using the "price" API from »