what is arre formula
Answers
Answered by
2
Explanation:
An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result
Answered by
0
Array Formula in Excel :
Explanation:
- The formula is present on the spreadsheet software or excels software which is used to perform some calculation for any cell after taking the value of some other cell value or some default value.
- The default value states the value which is defined at the time of formula and not found on any cell. For example, in "=sum(C1+5)", C1 Takes value from cell and 5 is the default value and the total statement is a type of formula.
- The array formula is a formula in which the argument is taken as a list. It means it takes the argument of many cells to perform a certain calculation. For example, "Sum(A1: A10)", is a type of array formula, because it takes the list of 10 cells to add the value.
Learn More :
- Excel : https://brainly.in/question/13842386
Similar questions