Question about Microsoft EXCEL 2004 for Mac

# Problem coming in subtraction

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

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

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

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

Posted on Feb 11, 2009

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How do I calculate 20% off

1. Divide 20 by 100 to convert 20 percent to the decimal 0.2.
2. Multiply 0.2 by the price of the item to calculate the amount of the discount. For example, if the original price of the item equals \$24, you would multiply 0.2 by \$24 to get \$4.80.
3. Subtract the value of the discount from the original price to find the price of the item after the discount. In this example, you would subtract \$4.80 from \$24 to find the price after the discount to be \$19.20.

Mar 03, 2015 | Mathsoft Computers & Internet

### Luke wants to find the difference 175 - 134. He has subtracted the hundreds and tens so far. What is the sum of the two numbers he has subtracted? How much does he still need to subtract?

SUM means adding not subtracting. so if you were wanting to add the total (the sum) of the amounts of the hundreds and the tens would be 170 plus 130 which would be 300 but the remainder from subtracting 130 from 170 would be 40. That would leave the single units 5 minus 4 of which the remainder is 1. So, the remainder from subtracting 134 from 175 is the reminder of subtracting the one hundred from the one hundred which is zero added to the remainder of subtracting the tens (70 minus 30) which is the remainder of 40 plus the remainder of subtracting the units of 5 minus 4 which is 1. So you need to add the 0 and the 40 and 1 which is the remaining sum of 41.

Sep 19, 2014 | Office Equipment & Supplies

### How to find the mean absolute deviation

Add all the numbers together to get the sum.
Divide the sum by the number of numbers to get the mean.
so you have
1,2,3,4, that is 10. divide ten by four. because there are 4 numbers.
you get 2.5. Take each number and subtract 2.5. Discard all the negatives from the pile. So in essence you are taking the above example and subtracting 2.5 from 3 and 4 because the other two are going to be negative. so the answer is 3 - 2.5 and 4 - 2.5 which is 2. then take that 2 and divide by the number of items that you subtracted from which is 2. 2/2 is 1. one is the mean standard deviation.

Apr 17, 2014 | Acer Computers & Internet

### I want to substract 15 per cent and is not accurate the substraction in this cannon p27 dh brand new. the same operation for adding 15 is ok

To subtract 15% from something, what I do is take the price of the item (let's say it costs \$100), then multiply it by 0.15 (which is equivalent to 15%). 100 x 0.15 gives you 15. Then, you'd take that number (15) and subtract it from the \$100 to get \$85, which is 15% off of \$100.

Mar 05, 2011 | Canon Office Equipment & Supplies

### How do I print the total amount on my ticker tape of what I've added? I pressed the equals sign but that didn't work.

OFF • P P•IC
ON POWER SWITCH; PRINT / ITEM COUNT MODE SELECTOR:
"OFF": Power OFF
"•": Power ON. Set to the non print mode.
"P": Power ON. Set to the print mode.
"P•IC": Power ON. Set to the print and item count mode.
1) For addition or subtraction, each time is pressed, 1 is added to the item
counter, and each time is pressed, 1 is subtracted.
• The count is printed when the calculated result is obtained.
• Pressing of , clears the counter.
2) When the grand total/rate setting mode selector is in the ON position (GT), the
counter will count the number of times that the calculation results have been
stored in the grand total memory. To print and clear the count, press the key.
3) The memory item counter will count the number of times that the key has
Note: • Each time the key is used in the subtraction, 1 will be subtracted from
the count.
• The count is printed when the memory is recalled.
• Pressing of the key clears the counter.
Note: The counter has a maximum capacity of 3 digits (up to ±999). If the count exceeds
the maximum, the counter will recount from zero.

Dec 17, 2010 | Sharp EL-1801P Calculator

### How do you subtract low numbers from high numbers

• Hi, to "Subtract a >Higher (#,\$) numbers from a <Lower (#, \$) numbers; you take the "bigger number 167, place that number (over the smaller number 78 and from (right to left) take away numbers. Example: 167 - 86 = Think of 167 as \$167.00 and 86 as \$86.00, so to make \$86.00 into \$167.00 you'll need a \$81.00 more. So if you think about how much more money you will need to "Add" to make a certain amount, it is just the same as how much you "Don't have! You have \$167.00 when you go shopping for clothes, and you spend \$86.00 when you count how must money you have left, it add up to \$81.00 "That's "Subtracting." "Subtract (167 from 86 you get 81). " Always remember the Higher, or Larger number goes on top! " If you want to check to see if the answer is "right," add the two number together,(86 + 81 = 167). "I hope this helped you, rating the solution is appreciated, thanks"

May 02, 2010 | School Zone Addition Subtraction Full...

### I can't seem to do simple subtraction with my Victor 1208-2. When I subtract say 5-4, I get a negative 9. Is there a setting or do I need to press something different to get simple subtraction to work?

When you want to complete a problem on an adding machine, such as "7 - 3," you would not key in "7," then the subtraction sign, then "3" and then an equal sign. If you do, then you will get an answer of "-4," and you know that is not the correct answer. Again, you have to think like an accountant when you are working with your adding machine. To figure this subtraction problem on an adding machine, you would need to key in "7," the addition sign, "3" and then the subtraction sign; you would get the answer of 4. You are actually working the problem as "7 + (-3)." This would be true on most modern day machines. In order to subtract, you have to add the negative number.

Sep 25, 2009 | Victor 1208-2 Calculator

### Subtract anything to get 2/7

Hello,
Subtract anything? From what?
Subtract 5/7 from 1 (which is 7/7) gives 2/7.
There are an infinity of ways to get 2/7
Hope it helps.

Sep 22, 2009 | Core Learning Fractions - Step By Step...

### Price subtracted from total.

Hi.
Sounds like dept 2 is set as a negative department. You need to change the sign of dept 2 to positive. Should be under department programming in the manual.

Jun 18, 2009 | Casio Parts Cash Register PC Desktop

### Excell

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 | Computers & Internet

## Open Questions:

#### Related Topics:

154 people viewed this question

Level 3 Expert

Level 3 Expert