0
What are brackets used for when creating a formula or calculation?
Wiki User
∙ 14y ago
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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is a calculation used to estimate the answer to a problem before doing an actual calculation called?
A formula.
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 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 is the answer to the carl friedrich gauss formula?
There are several formulae named after Gauss; anyway, a formula normally doesn't have a single answer, rather, the answer depends on the specific numbers used for the calculation.
What do the brackets stand for in spreadsheet?
Brackets are used in different ways in a spreadsheet. Most commonly you will see them in functions, with what is needed for the function, referred to as arguments, being put inside the brackets. All functions have brackets and most require that something is put inside them. Examples include the following:=SUM(A1:A15)=Left(A2,5)Brackets can be used in calculations to change the precedence of operators. This is standard from the laws of mathematics. For example, in mathematics you do all multiplications and divisions before any additions and divisions. The following calculation gives 20, not 60, because the multiplication has to be done first:=10+2*5To get the 10+2 done first, which will make the final result 60, you would include it in brackets, like this:=(10+2)*5Brackets are sometimes used to indicate negative numbers, instead of using the minus sign. The proper name for these kind of brackets or round brackets is parentheses. You will also see the curly brackets { and } which are properly called braces. They are used to indicate arrays, which are lists of values that can be used in formulas.
What are basketball brackets used for?
Basketball brackets are used in basketball tournaments to determine the winnners and other placements of the teams. There are several different types of brackets used in basketball tournaments.
What is the formula for calculation of catalase level?
The basic formula used to calculate catalase levels is (units/mg protein/min). Results differ according to provided information, and organisms in which it is present.
What formula is best for basic math using Microsoft Excel?
There is no single formula that can be said to be the best. Every calculation you do is different and there are different ways in Excel to do the same calculation. It will depend on the calculation you want. So the question cannot really be answered. Generally you can use the plus(+), minus(-), multiply(*) and divide(/) operators in Excel and they would be used in basic mathematical calculations. Functions like SUM can also be used to do some basic calculations.
