I wanna subtract two items but i did not find any solution of this.can u help me in this matter.

You just have to use the subtraction formula. The formula is as follows:

=A1 - A2

Where A1 and A2 are cells that contain the data that you would like subtracted. If you want just two numbers subtracted you can type them directly:

=20 - 10

for more information look at the subtraction section of the following link.

http://www.homeandlearn.co.uk/ME/mes5p1.html

Posted on Feb 11, 2009

- Select a cell
- in the Fx section type =SUM(
- Click another cell
- The cell should highlight and the Fx should display (for instance =SUM(C3
- modify the Fx to read =SUM(C3-
- Click another cell
- Fx should read (for instance) =SUM(C3-D3
- Modify the Fx to read =SUM(C3-D3) by adding a closing bracket
- Put a number in C3
- Put a number in D3
- B3 will display the result of the subtraction

Mar 08, 2015 | Microsoft Excel 2010

You have to start the sequence with a slightly different formula because there is no preceding value for Monday.

The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.

Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.

Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

That depends on whether you are using QuickBooks, or QuickBooks Point of Sale.

For QuickBooks, one of the fastest ways to determine the number of Items, is to export the Items list to an exel spreadsheet. Once there, you subtract the number of rows used for header information.

This is important information to know, as with the quickbooks, you may run into a list limitation of 10,000 items ( or listings in the items list, this will include inactive items and sales tax items, non-inventory items and such.).

To export the lists, you should find a listing under the file menu.

If you are using Point of Sale, for versions 1 to 3, your list limits are 30,000. For versions 4 and up, there was a change to the databases that makes them pretty much unlimited. The latest version, 7, will tell you the number of items at the bottom of the items list screen.

For QuickBooks, one of the fastest ways to determine the number of Items, is to export the Items list to an exel spreadsheet. Once there, you subtract the number of rows used for header information.

This is important information to know, as with the quickbooks, you may run into a list limitation of 10,000 items ( or listings in the items list, this will include inactive items and sales tax items, non-inventory items and such.).

To export the lists, you should find a listing under the file menu.

If you are using Point of Sale, for versions 1 to 3, your list limits are 30,000. For versions 4 and up, there was a change to the databases that makes them pretty much unlimited. The latest version, 7, will tell you the number of items at the bottom of the items list screen.

Aug 23, 2008 | 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

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

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

npbhoge@rediff.com

Jul 29, 2008 | Microsoft Excel for PC

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

Jul 13, 2008 | Microsoft Excel for PC

Sorry, I don't clearly understand what you want to do, but if you can explain a little more, I can help. If you want to subtract one cell from a column total, sum the column and subtract the one cell. If there is a need to subtract adjacent column entries, or similar type needs, there are formulas that can do this easily as well. Just a little more info - we'll have a FixYa!

Apr 27, 2008 | Business & Productivity Software

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

147 people viewed this question

Usually answered in minutes!

×