Sheetgo Blog

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

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

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

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

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

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

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

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

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

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

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