Level 3 spreadsheeets

mighty18
AAT Student Posts: 16
Could someone please tell me what an array formula is? I know, it is not rocket science; but, a good explanation would benefit my understanding.
0
Comments
-
I had to look this up...because my own version of Excel (Excel 2000) seriously predates this particular function being introduced! xD
Basically, an array formula is a single formula that works on an entire set of cells, and and collects a set of formulae together.
Say you have two columns of data in your spreadsheet - column A is quantity, column B is unit price.
Normally, to work out totals of each item, the cells in column C would have the formulae:
=A1*B1 (for C1)
=A2*B2 (for C2)
=A3*B3 (for C3)
...and so on. Let's say there were 100 different items. The last one would be =A100*B100
But instead, an array formula would collect all of these into one, as follows:
=A1:A100*B1:B100
This formulae is telling Excel to mutiply the first cell in the first range (A1) by the first cell in the second range (B1), then doing the same with the second cell in each (A2*B2) and so on, down to 100.
I hope that helps.Accounts Executive, ғɪᴀʙ ᴍᴀᴀᴛ
QBO & Xero certified advisor
AAT
Level 2 Certificate in Accounting - 17 Jun 2015
Level 3 Diploma in Accounting - 22 Jan 2016
Level 4 Diploma in Accounting - 19 Dec 2017
MAAT - 27 Mar 2018
ACCA
Advanced Diploma in Accounting and Business...
F4 Corporate and Business Law - 4 Jun 2019
F5 Performance Management - 15 July 2019
F6 Taxation (United Kingdom) - 3 Dec 2019
F8 Audit and Assurance - 2 Mar 20201
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 18.9K For AAT students
- 234 NEW! Qualifications 2022
- 133 General Qualifications 2022 discussion
- 7 AAT Level 2 Certificate in Accounting
- 31 AAT Level 3 Diploma in Accounting
- 55 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 91 Software
- 272 Tax
- 135 Bookkeeping
- 7.3K General accounting discussion
- 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
- 3.8K For everyone
- 39 AAT news and announcements
- 352 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 586 Job postings
- 17 Who can benefit from AAT?
- 36 Where can AAT take me?
- 44 Getting started with AAT
- 26 Finding an AAT training provider
- 47 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 65 AAT membership