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
34,890,732
*
Get answers from Weegy and a team of really smart live experts.
Popular Conversations
The correct plural of the noun attorney is _______. The primary ...
Weegy: The correct plural of noun attorney is attorneys.
______ contain close to 70% of all the fresh water on Earth. _______ ...
Weegy: Glaciers contain close to 70% of all the fresh water on Earth.
______ contain close to 70% of all the fresh water on Earth. _______ ...
Weegy: The ice caps and glaciers contain close to 70% of all the fresh water on Earth. [ Wind erosion is common on ...
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 ...
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.
A stream s velocity is _______ at the bottom and edges. A stream s ...
Weegy: A stream velocity is slowest at the bottom and edges.
The four main purposes for academic writing are to _______, _______, ...
Weegy: The four main purposes for academic writing are to Inform, Entertain, Persuade, and Convince.
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 ...
S
L
Points 217 [Total 665] Ratings 0 Comments 197 Invitations 2 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 174 [Total 585] Ratings 2 Comments 154 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
L
Points 53 [Total 894] Ratings 0 Comments 53 Invitations 0 Offline
S
Points 42 [Total 42] Ratings 0 Comments 42 Invitations 0 Offline
S
Points 35 [Total 35] Ratings 1 Comments 25 Invitations 0 Offline
S
L
1
1
1
1
1
1
1
1
Points 30 [Total 2924] Ratings 3 Comments 0 Invitations 0 Online
S
L
1
1
1
Points 21 [Total 3596] Ratings 2 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.