Google Sheets formulas articles

Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many...

In this post, learn how to calculate the normal cumulative distribution by using the NORMSDIST formula in Google...

We are aware of the important role, the normal cumulative distribution plays in the field of statistics. We can derive...

Data is what the spreadsheets are built for – and helping us analyze it is its primary goal. There are some key...

Spreadsheets are where most of us do our data analysis on. For that reason, we have many formulas and tools to aid us...

Various spreadsheets programs that we have been using have one main goal. To help us understand the underlying data....

While the first parameter accepts only range references, the second parameter can take both direct numbers as well as...

The TIME formula in Google Sheets accepts a given time through the hour, minute, and second component values, and...

In our day to day lives, we will be needing to do certain activities that may be time-sensitive. There can be business...

At times we may need to pick the hour from a time value. Possibly to use it with another formula that calculates an...

Let’s say we need to know how far two different dates are separated from each other, based on the 360 day year....

Almost all of us at some point in our lives may opt for loans, against a prevailing interest rate. And we’d be...

Depending on the buyer’s preferences, there are periodic investments as well as fixed investments to choose from....

Given the periodic interest rate and expected yield, do you need to calculate the price of an investment or a...

All of us try and invest our money in some assets. So, we would definitely want to know how much value our future...

Let’s assume that we have a number of periodic constant-value payments to make against an investment. So naturally, we...

There are usually two kinds of assets – appreciating and depreciating assets. While investments such as stocks, bonds...

Given the expected yield that an investment and the interest rate, the MDURATION formula in Google Sheets calculates...

With the DISC formula in Google Sheets, we can calculate a security’s discount rate based on its price. This is one of...

Do you need to calculate the number of compounding periods that an investment required to reach a target value?...

With the NOMINAL interest rate formula in Google Sheets, we can calculate the annual nominal interest rate. We just...

Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of...

In Google Sheets, if you need to know what specific week of the year a date falls on, you can use the WEEKNUM formula...

In Google Sheets, if we need to know how far two different dates are separated from each other, we can make use of...

The ROW formula is one of the lookup functions available within Google Sheets. It gives us the row number where the...

The COLUMN formula is one of the lookup functions available within Google Sheets. It gives us the column number where...

In Google Sheets application, if we need to know the date a specified number of months before or after a given date,...

In Google Sheets application, if we need to know the number of net working days between two specified dates,...