Question about Microsoft Excel for PC

- How to make subtraction, additions and divisions using excell sheets.

Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.

You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

Posted on Aug 07, 2008

Just put the "=" sign in front and input the equation (subtraction, addition, and division) inside the cell

Otherwise, you can also put the numbers in each separate cell, and then have a cell for equation like =C1+C2

C1 and C2 are references for the cells that you enter the number

So if you input "5" in C1 and "6" in C2, the cell with the equation =C1+C2 will show "11"

Posted on Aug 01, 2008

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

In answer to your first question:

you need to type this in F12:

=D12*E12

That will take the value in cell D12 and multiply it by the value in E12. You can use the same layout for addition, subtraction, and division. For your second question type the following in cell J2:

=F2+i2

The "=" sign is important because it tells Excel that you are putting a function into the cell and to display the results, not what you actually typed.

The answer to your third question is a bit trickier but still easy to do.

Click on cell J131

Then click on the black arrow on the Autosum button, it looks like this:

and select sum. This will put a dotted-line box around the data directly above it. You can change what is selected by clicking on various cells, I suggest you play around with this. When you have the range of cells that you want summed up, just hit enter.

you need to type this in F12:

=D12*E12

That will take the value in cell D12 and multiply it by the value in E12. You can use the same layout for addition, subtraction, and division. For your second question type the following in cell J2:

=F2+i2

The "=" sign is important because it tells Excel that you are putting a function into the cell and to display the results, not what you actually typed.

The answer to your third question is a bit trickier but still easy to do.

Click on cell J131

Then click on the black arrow on the Autosum button, it looks like this:

and select sum. This will put a dotted-line box around the data directly above it. You can change what is selected by clicking on various cells, I suggest you play around with this. When you have the range of cells that you want summed up, just hit enter.

Mar 23, 2009 | Microsoft Office Standard for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

Are you using live cycle (Part of Adobe 8)

On the RAW form - select from main bar - Window, Script Editor

Your Addition or Subtraction will be :

Field 1 + Field 2 or Filed 1 - Field 2

For division, change this to Field1 / Field2

For multiplication, Field1 * Field2

I have a PDF (Created in Livecycle that calculate standard deviation in tabular format) - currently working on the graphical representation

On the RAW form - select from main bar - Window, Script Editor

Your Addition or Subtraction will be :

Field 1 + Field 2 or Filed 1 - Field 2

For division, change this to Field1 / Field2

For multiplication, Field1 * Field2

I have a PDF (Created in Livecycle that calculate standard deviation in tabular format) - currently working on the graphical representation

Aug 13, 2008 | Business & Productivity Software

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Business & Productivity Software

meri excel file ka security paasward missing. Pls i want track the paasward.

Jul 13, 2008 | Microsoft Excel for PC

Hello!

Have you tried a simple restart of Excel and/or your computer? That would be my 1st recommendation. If that doesn't work, make sure the font formatting for the cells is correct (this seems simple but could be overlooked perhaps). If that doesn't work you may try to repair/reinstall Excel (use the Office disc).

Let me know if you need additional help or if that doesn't work. Any additional information you can provide would be very helpful though.

Best of luck!

Heather

Have you tried a simple restart of Excel and/or your computer? That would be my 1st recommendation. If that doesn't work, make sure the font formatting for the cells is correct (this seems simple but could be overlooked perhaps). If that doesn't work you may try to repair/reinstall Excel (use the Office disc).

Let me know if you need additional help or if that doesn't work. Any additional information you can provide would be very helpful though.

Best of luck!

Heather

Jan 10, 2008 | Microsoft Excel for PC

Dear pauline, you can link cells in formula bar to see immediate effect of additions and subtractions in dependent boxes.

Like for example you add three numbers in three boxes A1, B1, C1 and answer is supposed to go in D1, just type =SUM(A1+B1+C1)

in D1.

now when you will change the values of a b and c boxes, the value of d1 will automatically change. for adding more numbers you can leave boxes empty so that you can fill in later to see the change in the sum box.

please press fixya if that has helped you.

Like for example you add three numbers in three boxes A1, B1, C1 and answer is supposed to go in D1, just type =SUM(A1+B1+C1)

in D1.

now when you will change the values of a b and c boxes, the value of d1 will automatically change. for adding more numbers you can leave boxes empty so that you can fill in later to see the change in the sum box.

please press fixya if that has helped you.

Dec 11, 2007 | Business & Productivity Software

Jan 28, 2016 | Microsoft Excel for PC

344 people viewed this question

Usually answered in minutes!

×