how to create a formula in Excel?
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. ]
Question
Updated 5/20/2014 4:17:02 AM
s
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.
Rated good by niKlaus

Questions asked by the same visitor
writing of formula in Excel?
Weegy: 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. ] (More)
Question
Updated 5/20/2014 4:17:53 AM
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.
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
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
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
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
35,149,786
Popular Conversations
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.
The correct plural of the noun attorney is _______. The primary ...
Weegy: The correct plural of noun attorney is attorneys.
For each blank, write a word that is an antonym of the italicized ...
Weegy: He couldn t bear the cold of Alaska after living in the HEAT of Texas.
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 ...
_______ 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 ...
The _______ step of the writing process entails coming up with ideas. ...
Weegy: The Brainstorming step of the writing process entails coming up with ideas. The planning step entails: ...
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.
S
L
Points 515 [Total 515] Ratings 1 Comments 495 Invitations 1 Offline
S
L
Points 435 [Total 435] Ratings 5 Comments 385 Invitations 0 Online
S
R
L
P
P
Points 285 [Total 3703] Ratings 0 Comments 285 Invitations 0 Offline
S
L
P
R
Points 236 [Total 1085] Ratings 0 Comments 226 Invitations 1 Offline
S
L
Points 235 [Total 1250] Ratings 0 Comments 235 Invitations 0 Offline
S
L
P
P
Points 197 [Total 4144] Ratings 0 Comments 197 Invitations 0 Offline
S
L
Points 163 [Total 163] Ratings 0 Comments 163 Invitations 0 Offline
S
L
Points 109 [Total 109] Ratings 0 Comments 109 Invitations 0 Offline
S
L
Points 67 [Total 418] Ratings 2 Comments 47 Invitations 0 Offline
S
L
Points 61 [Total 209] Ratings 3 Comments 31 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.