0
Brackets are used for creating an array formula.
From Microsoft:
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. For example, you can place an array formula in a range of cells and calculate a column or row of subtotals. You can also place a formula in a single cell and calculate a single amount. An array formula that resides in multiple cells is called (logically enough) a multi-cell formula, and an array formula that resides in a single cell is called a single-cell formula.
To multiply the values in the array (the cell range C2 through D11), select cells E2 through E11, and then enter the following formula in the formula bar:
=C2:C11*D2:D11
Press CTRL+SHIFT+ENTER to enter the array formula (and observe the brackets in the formula).
TIP: If you later go back and edit the array formula, remember to press CTRL+SHIFT+ENTER. Don't just press ENTER or you will destroy the array formula and display an error message until you go to the cell and press CTRL+SHIFT+ENTER again.
What else can I help you with?
What is a calculation used to estimate the answer to a problem before doing an actual calculation called?
A formula.
How do you calculate distance in physics and what formula is used for this calculation?
Distance in physics is calculated by multiplying the speed of an object by the time it takes to travel that distance. The formula used for this calculation is: Distance Speed x Time.
What are three parts of a formula?
Three parts of a formula include the equal sign to start the equation, cell references or values used in the calculation, and mathematical operators (+, -, *, /) to perform the calculation.
How is mass divide by volume?
This formula is used in the calculation for density, Density=mass/volume,normally in the calculation of liquid volume or density.
How is mass divided by volume done?
This formula is used in the calculation for density, Density=mass/volume,normally in the calculation of liquid volume or density.
Why do parameters create the most energy?
What do you mean? A parameter is a number used in a calculation. That has nothing to do with creating energy.
What is the force calculation formula used to determine the impact of external forces on a system?
The force calculation formula used to determine the impact of external forces on a system is Newton's second law of motion, which states that force equals mass times acceleration (F ma).
Why are brackets necessary in chemistry?
Brackets are necessary as it helps to differentiate between the different parts of chemical formulae. For example, take ammonium hydrogen phosphate. The chemical formula is: (NH4)2HPO4. The brackets signify that there are two NH4 atoms in the formula. If the brackets weren't there then it would be: NH42HPO3. Now it looks like that the one nitrogen atom is bonded to 42 hydrogen atoms and one phosphate molecule.
What is the formula used in diesel index calculation?
diesel index = aniline point *API(1/100)
What is the name given to built in calculations?
SUM is a function. It can be used as part of a formula which can carry out a calculation.
What is the syntax for entering functions in Microsoft Excel?
All functions start with a name and are followed by brackets. After that, each function is different. Some functions have nothing inside the brackets but most do. What is inside the brackets will depend on the function. So there is not a standard syntax for functions, other than having a name and brackets. In order to use them in a formula, there must be an equals sign at the very beginning of the formula. More than one function can be used inside a function, but the equals sign is only required at the beginning of the formula.
What type of brackets are commonly used to support shelves?
The type of brackets commonly used to support shelves are L-shaped brackets.
