Google Sheets

AMORLINC: Google Sheets Formulae Explained

How do you use AMORLINC in Google Sheets?

AMORLINC is a Google Sheets add-on that allows you to quickly and easily find and merge duplicate cells in your spreadsheet. To use AMORLINC, first install the add-on from the Google Sheets add-ons store. Then, open a spreadsheet and select the "Add-ons" menu in the top toolbar. Select "AMORLINC" and then "Start." The AMORLINC dialog will open.

To find and merge duplicate cells, select the "Duplicate Cells" tab and then click the "Scan" button. The add-on will scan your spreadsheet for duplicate cells and will display them in the grid on the left-hand side of the dialog. To merge duplicate cells, select the cells you want to merge and then click the "Merge" button. The merge dialog will open, allowing you to choose the merge method and options.

Once you have merged the duplicate cells, the "Results" tab will show the number of duplicates that were found and merged.

What is the syntax of AMORLINC in Google Sheets?

The syntax of the AMORLINC function in Google Sheets is as follows:

=AMORLINC(log_base, num1, num2)

This function calculates the logarithm of a number to the given base, and then returns the value of the number at that logarithmic point. The first two arguments are the logarithmic base and the number to calculate, while the third argument is the number of decimal places to round the result to.

What is an example of how to use AMORLINC in Google Sheets?

The example below demonstrates how to use the AMORLINC function in Google Sheets. In this example, the formula returns the value "1.5" which is the annualized monthly return for the stock over the past year.

=AMORLINC("GOOGL",A1,12)

When should you not use AMORLINC in Google Sheets?

There are a few instances in which you should not use AMORLINC in Google Sheets. If you have a large spreadsheet with complex formulas, AMORLINC can slow down the calculation time. Additionally, if you have multiple people working on the same spreadsheet, using AMORLINC can create conflicts.

What are some similar formulae to AMORLINC in Google Sheets?

There are a few similar formulae to AMORLINC in Google Sheets. The SUMIFS function can be used to add up the values in a range of cells that match certain criteria. The VLOOKUP function can be used to lookup values in a table of data. The INDEX and MATCH functions can be used to lookup values in a table of data and return the corresponding row and column number. Finally, the QUERY function can be used to query and filter data from a table of data.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.