2007-07-23 10:21:14 · 9 answers · asked by Anonymous in Computers & Internet ➔ Software
=SUM(C5+(-D5))
Treat the number you want to subtract as a negative number. In this case I wanted to subtract D5 from C5 so I made D5 a negative number, by putting a minus sign in front of it. Don't forget to seperate the negative number from the rest of the equasion with parenthessis.
2007-07-23 10:30:40 · answer #1 · answered by barrywhy 1 · 0⤊ 0⤋
Type "=10-1" in any cell. and hit enter.
(use the stuff in between the" ", not the " themselves.)
Or type "10" in A1, type "1" in A2, and type
"= A1 - A2"
in A3.
You can also use the excel help files to answer your questions. It is in the upper right hand corner of excel it says "Type a question for help". if you can't see those words, maximize your excel screen and look again, it should be there. In this case you could type in "subtraction" in that space and hit enter. These are useful help files, and they are built-in, no need to go online:).
If for whatever reason you want other resources, there are also google groups for excel and other online groups and messageboards resources for excel questions and answers.
When you have time, check out some excel GAMES, internet search Kouichi Tani or Keisuke Yuuki for their games!
2007-07-23 17:41:24 · answer #2 · answered by jonathan k 2 · 0⤊ 0⤋
lets say you have 10 in cell a1 and 5 in cell a2
your subtraction formula is
=sum(a1-a2)
you might be able to get away with
=(a1-a2)
if you want to multiply in excel, you use * that's the star above 8
adding in excel, you use +
dividing in excel, you use /
2007-07-23 17:27:15 · answer #3 · answered by zanthus 5 · 0⤊ 0⤋
You need a formula to subtract?
2007-07-23 17:24:01 · answer #4 · answered by philip_jones2003 5 · 0⤊ 1⤋
Just use a minus sign??
Type =12-8 into a cell.
Or =c1-c2
2007-07-23 17:24:44 · answer #5 · answered by hottotrot1_usa 7 · 0⤊ 0⤋
you just simply put the cell number and the minus and the other cell number
go to insert > function > choose what u need to do
2007-07-23 17:25:44 · answer #6 · answered by scarface 2 · 0⤊ 0⤋
you put in the formula bar =watever - watever
eg. =e5-g5
2007-07-23 17:24:53 · answer #7 · answered by Krissy 2 · 0⤊ 0⤋
its the dash key ( - ) for example [ =c21-c23 ]. That what you mean?
2007-07-23 17:24:10 · answer #8 · answered by Danny N 4 · 0⤊ 0⤋
example: =b4-b3
2007-07-23 17:24:02 · answer #9 · answered by steven25t 7 · 0⤊ 0⤋