How to write an equation in excel -urgent

Asked By Thomas Maloy 0 points N/A Posted on - 03/09/2012

Hello,

I need to write few equations in excel but I do know the method to do so. I am requesting assistance from someone who knows how to write an equation in excel so that I will be able to cover my task in time. Please kindly someone help me over come this issue as soon as possible.

Thomas Maloy

• Status: Open
• Question Views: 1361
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Pallasigue Stabins

Go To Solution

Answered By Tanok Bloran 80 points N/A #116742

How to write an equation in excel -urgent

Formulas are the equations that we create to perform calculations of values in our worksheet, and it always starts with the equal sign. Simple formulas are created by using constants and calculation operators. Function can also be use to create these formulas. Here are the steps on how to create a simple formula for your Excel worksheet or database:

1. Start your Microsoft Excel and open the file that you would like to change
2. This time, double-click on the cell where you would like to total to show
3. Once there, press the equal sign on your keyboard.
4. Now, enter the formula you would like to use and hit Enter.
5. After that, enter an open-parenthesis
6. Then a cell name
7. Press the plus key this time
8. Then enter another cell name, don’t forget the close-parenthesis this time
9. Now, enter a minus sign and your third cell name
10. Hit Enter
11. You have then just created the formula (a+b)-c wherein, the total would be the result of adding a to b then subtracting c from its sum

About Tanok Bloran

Questions
2

Answers
315

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 03/09/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Pallasigue Stabins 0 points N/A #116744

How to write an equation in excel -urgent

Are you ready to make your own function (equation). Then let’s do it. In excel, there is a single keystroke which informs excel program of your intention. At first press the equal key (=). After writing the equation, excel can do the rest calculation. I will deal with four simple functions:

1.       Add

2.       Subtract

3.       Multiply

4.       Divide

The equation can be written exactly like that ( =6+3 ) and Excel will display the expected answer, 9.

Similarly, you can add, subtract, multiply, divide using the  below ways.

I think i have made easier for you to use equation.

Hope this helps you.

 

About Pallasigue Stabins

Questions
1

Answers
63

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 03/23/2012
• Question Category: MS Excel

Answered By Thomas Maloy 0 points N/A #116745

How to write an equation in excel -urgent

Whoa, Excel is really tricky, and thank you for all your solutions! I should get a hang of this thing since I will be working with more equations in the future

About Thomas Maloy

Questions
15

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/10/2012
• Question Category: MS Excel