What is an array formula?

Array formula often provide a shortcut or more efficient approach to performing complex calculations in Google Spread sheets. An array formula can return a result in either one cell or in a range of cells. Array formula perform operations on two or more sets of values, called array argument. Each array argument used in an array formula must contain exactly the same number of rows and columns.

When entering an array formula,  the first function will be arrayformula and then select the formulas which you want Google Spread sheet to place the array formula. Or otherwise you can write the formula followed by Control+Shift+Enter(window) or Command+Shift+Enter (Mac) google docs will automatically put entire formula in side arrayformula.

To understand arrayformula’s visit the Google Docs forum at the following link



One Response to What is an array formula?

  1. bqakdeyzgru says:

    AcV0FY rowbhauidgpi, [url=http://zjbxcbwgrrlk.com/]zjbxcbwgrrlk[/url], [link=http://srkxvtezemaq.com/]srkxvtezemaq[/link], http://sdahnzvxkfix.com/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: