answersLogoWhite

0

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*5

To get the 10+2 done first, which will make the final result 60, you would include it in brackets, like this:

=(10+2)*5

Brackets 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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What does the brackets stand for in math?

Brackets are a way of ordering the priority of operations. In mathematics, usually things with brackets have their operations completed first.


What does the acronym OLE stand for pertaining to a spreadsheet?

Object Linking and Embedding.


What does parentheses or brackets stand for in algebra?

the brackets mean "do this first". for example, in: x(4+2) you would add 4+2 before multiplying it By x. you can also add brackets into brackets which do the same thing. it is not compulsory, but you may change the brackets for how far in they are. i.e {[(1)]}.


What is a stand alone spreadsheet?

A standalone spreadsheet is a spreadsheet file that exists independently without being linked to any other external data sources or software applications. It typically contains data organized in rows and columns, with formulas, functions, and charts to analyze and present the information. Standalone spreadsheets are commonly used for tasks such as budgeting, financial analysis, data management, and reporting. Examples of standalone spreadsheet software include Microsoft Excel, Google Sheets, and Apple Numbers.


What is the acronym bedmas stand for?

Brackets Exponents Division Multiplication Addition Subtraction


What do the letters BEDMAS stand for?

Brackets Exponents Division Multiplication Addition Subtraction


What do parenthesis or brackets stand for in algebra?

That everything within the brackets will get calculated first. So if you'd have (5*2)+3, the part in the brackets would get calculated first. So it would actually make it 10+3


What does .wk1 stand for?

.wk1 is a file extenstion that represents a spreadsheet file associated with Lotus 1-2-3, the first major spreadsheet application developed by Lotus Software - just as the file extention .xls would represent a Microsoft Excel spreadsheet file.


What does wk1 stand for?

.wk1 is a file extenstion that represents a spreadsheet file associated with Lotus 1-2-3, the first major spreadsheet application developed by Lotus Software - just as the file extention .xls would represent a Microsoft Excel spreadsheet file.


What is another name for worksheets in excel?

A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.


What is another name for worksheet?

A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.A spreadsheet or a sheet.


What does bimdas stand for?

Bimdas stands for: BRACKETS INDICIES MULTIPLICATION DIVISION ADDITION SUBTRACTION So enjoy...