Question and answer
writing of formula in Excel?
One of the first things to understand about Excel is it doesn't work the same way as a calculator. For example, if you type 4 + 3 x 2 into your calculator you'll get the answer 14. [ If you type this formula into a cell in Excel, you'll get a total different result:=4+3*2 Excel gives the answer 10. If you have a mathematical background, you'll know why Excel gives a different answer to such a simple calculation - and why, technically, Excel is right. If you don't have a math background this is very confusing indeed. Excel is applying a mathematical rule called Order of Precedence. This
rule specifies the order in which mathematical calculations should be performed. One part of that rule says that multiplication and division should be performed before addition and subtraction. Because of this Excel multiplies 3 by 2 and then it adds 4 to the result giving the answer 10. ]
Expert answered|selymi|Points 9826|
Question
Asked 1/4/2013 12:32:57 PM
Updated 5/20/2014 4:17:53 AM
1 Answer/Comment
This answer has been confirmed as correct and helpful.
s
Get an answer
New answers
Rating
6
To create a formula in excel you must start with an (=) equal sign then it could be followed by a function name, cell reference, an operator then probably constants. For a simple formula simply type a combination of numbers and operators; for example, 3+7.
Added 5/20/2014 4:17:53 AM
Rated good by niKlaus
Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
Questions asked by the same visitor
how to create a formula in Excel?
Weegy: How to Create an Excel Formula: 1. Double-click on the cell where you want the total to appear. 2. Press the = key on the keyboard. 3. Enter the formula, then press Enter. 4. Enter an opening parenthesis character: (. 5. Enter a cell name. [ For example: =(E2. 6. Press the + key. 7. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). 8. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. 9. Press the Enter key to accept the formula. ] (More)
Question
Expert Answered
Updated 5/20/2014 4:17:02 AM
1 Answer/Comment
To create a formula in excel you must start with an (=) equal sign then it could be followed by a function name, cell reference, an operator then probably constants. For a simple formula simply type a combination of numbers and operators; for example, 3+7.
Added 5/20/2014 4:17:02 AM
Rated good by niKlaus
explain the financial statements' purpose
Weegy: The purpose of financial statements is to provide information about the financial position, performance and changes in financial position of an enterprise that is useful to a wide range of users in making economic decisions. [ ] (More)
Question
Expert Answered
Asked 1/5/2013 9:22:56 AM
0 Answers/Comments
explain the financial statement purpose
Weegy: The objective of financial statements is to provide information about the financial position, performance and changes in financial position of an enterprise that is useful to a wide range of users in making economic decisions. [ ] (More)
Question
Expert Answered
Asked 1/5/2013 9:44:27 AM
0 Answers/Comments
What rules of accounting impact a business'
Weegy: The CPA rules, the tax laws, and the rules set by company management and Board of Directors.Most businesses typically use one of two basic accounting methods in their bookkeeping systems: cash basis and accrual basis. [ While most businesses use the accrual basis, the most appropriate method for your company depends on your sales volume, whether or not you sell on credit, and your business structure. The cash method is the most simple in that the books are kept based on the actual flow of cash in and out of the business. Income is recorded when it is received, and expenses are reported when they are actually paid. The cash method is used by many sole proprietors and businesses with no inventory. ] (More)
Question
Expert Answered
Asked 1/6/2013 11:50:22 AM
0 Answers/Comments
What classifies a white collar crime?
Weegy: Although there has been some debate as to what qualifies as a white-collar crime, the term today generally encompasses a variety of nonviolent crimes usually committed in commercial situations for financial gain. [ ] (More)
Question
Expert Answered
Asked 1/10/2013 8:59:03 PM
0 Answers/Comments
34,880,892
questions answered
Popular Conversations
The correct plural of the noun attorney is _______. The primary ...
Weegy: The correct plural of noun attorney is attorneys.
12/3/2021 7:52:06 PM| 14 Answers
______ contain close to 70% of all the fresh water on Earth. _______ ...
Weegy: Glaciers contain close to 70% of all the fresh water on Earth.
12/6/2021 2:35:52 PM| 9 Answers
For each blank, write a word that is an antonym of the italicized ...
Weegy: 1. He couldn't bear the cold of Alaska after living in the heat of Texas. He has been accused of theft, but we ...
12/1/2021 5:52:40 PM| 8 Answers
1. What was the purpose of the Articles of Confederation? 2. When ...
Weegy: The purpose of the articles of confederation was To create a system of government to run the nation.
12/2/2021 7:00:06 PM| 7 Answers
A stream s velocity is _______ at the bottom and edges. A stream s ...
Weegy: A stream velocity is slowest at the bottom and edges.
12/6/2021 9:20:14 PM| 5 Answers
The four main purposes for academic writing are to _______, _______, ...
Weegy: The four main purposes for academic writing are to Inform, Entertain, Persuade, and Convince.
11/29/2021 9:35:28 PM| 5 Answers
The painting _______ is an example of a political work of art. A/an ...
Weegy: The painting Massacre in Korea is an example of a political work of art. A carving is a design or impression ...
12/4/2021 12:38:26 AM| 4 Answers
The four main purposes for academic writing are to _______, _______, ...
Weegy: The four main purposes for academic writing are to Inform, Entertain, Persuade, and Convince.
12/7/2021 7:36:58 PM| 4 Answers
S
L
Points 198 [Total 646] Ratings 0 Comments 188 Invitations 1 Offline
S
L
P
P
L
P
P
P
L
P
Points 177 [Total 10354] Ratings 2 Comments 157 Invitations 0 Offline
S
L
Points 173 [Total 584] Ratings 2 Comments 153 Invitations 0 Offline
S
L
Points 93 [Total 226] Ratings 0 Comments 93 Invitations 0 Offline
S
Points 91 [Total 91] Ratings 0 Comments 91 Invitations 0 Offline
S
Points 42 [Total 42] Ratings 0 Comments 42 Invitations 0 Offline
S
L
1
1
1
Points 21 [Total 3596] Ratings 2 Comments 1 Invitations 0 Online
S
L
Points 20 [Total 861] Ratings 0 Comments 20 Invitations 0 Offline
S
L
R
R
Points 19 [Total 539] Ratings 0 Comments 19 Invitations 0 Offline
S
Points 10 [Total 54] Ratings 0 Comments 0 Invitations 1 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.