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.
g
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
35,206,423
questions answered
Popular Conversations
How many syllables are in the word ...
1/25/2022 11:23:50 PM| 15 Answers
What technology restored a demand for slaves in the US South in the ...
Weegy: Cotton gin restored a demand for slaves in the US South in the early 1800s.
1/18/2022 11:02:58 PM| 14 Answers
The correct plural of the noun attorney is _______. The primary ...
Weegy: The correct plural of noun attorney is attorneys.
1/18/2022 4:14:38 AM| 13 Answers
Questions 1 10: Fill in the blank space with an antonym of the ...
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 ...
1/27/2022 5:25:42 AM| 9 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. Wind erosion is most common in flat, bare areas ...
1/25/2022 1:22:35 AM| 8 Answers
Which empire was very populous, containing more than all of Europe,s ...
Weegy: The Roman empire was very populous, containing more than all of Europe's population at the time. User: Fill in ...
1/22/2022 1:12:42 PM| 6 Answers
How do oxides differ from other minerals that contain oxygen atoms?
Weegy: Oxides differ from other minerals that contain oxygen atoms in that: In oxides, the oxygen atoms bond directly ...
1/26/2022 1:18:05 AM| 6 Answers
Fill in the blank. One of the best reasons to write is to _______ ...
Weegy: One of the best reasons to write is to express what we think.
1/24/2022 3:21:34 AM| 5 Answers
S
L
Points 650 [Total 650] Ratings 1 Comments 630 Invitations 1 Offline
S
L
Points 628 [Total 628] Ratings 9 Comments 538 Invitations 0 Offline
S
R
L
P
P
Points 380 [Total 3798] Ratings 0 Comments 380 Invitations 0 Offline
S
L
Points 352 [Total 1367] Ratings 0 Comments 352 Invitations 0 Offline
S
L
P
R
Points 333 [Total 1182] Ratings 0 Comments 323 Invitations 1 Offline
S
L
P
P
Points 221 [Total 4168] Ratings 0 Comments 221 Invitations 0 Offline
S
L
Points 163 [Total 163] Ratings 0 Comments 163 Invitations 0 Offline
S
L
Points 119 [Total 119] Ratings 1 Comments 109 Invitations 0 Online
S
L
Points 91 [Total 442] Ratings 2 Comments 71 Invitations 0 Offline
S
L
1
1
1
1
1
1
1
1
Points 80 [Total 3064] Ratings 8 Comments 0 Invitations 0 Online
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.