What is the formula for subtracting two cells.
E.g SUM is add
AVERAGE IS average
What is subtract?
2007-02-01 21:04:06 · 8 answers · asked by jdratbull 2 in Computers & Internet ➔ Software
= first cell - second cell
i.e.
= A1 - A2
2007-02-01 21:08:01 · answer #1 · answered by Stu 2 · 3⤊ 0⤋
Lemme wager, you're in a working laptop or laptop Literacy classification... possibly with the paintings Institute??? by using fact whats humorous is this is the right question of this weeks first task. strange. "Week 3: Week 3 - W3: task a million communicate communicate question 3 evaluate Microsoft observe, Microsoft Excel, and Microsoft PowerPoint. whilst might desire to you utilize each of those applications? whilst are you able to apply those applications interchangeably? provide examples and motives to assist your answer."
2016-12-16 19:20:22 · answer #2 · answered by Anonymous · 0⤊ 0⤋
SUM tells excel to expect a calculation, i.e. add subtract, divide, multiply or resolve a formula.
So subtract would be sum(b12-b10) i.e subtract the sum in b10 from the sum in b12
To subtract the sum of 2 columns would be
SUM((b12:b24)-(c12:c24))
That formula would subtract the total of cells c12 to c24 from the total of b12 to b24
OK?
2007-02-01 21:18:38 · answer #3 · answered by DavidP 3 · 1⤊ 0⤋
'-' is the subtract sign, as the other answers mention do =sum(a1-b1)
2007-02-01 22:22:52 · answer #4 · answered by Vinz 3 · 0⤊ 0⤋
just minus sign
ie =A1-B1
2007-02-01 21:10:41 · answer #5 · answered by ravydavygravy01 3 · 1⤊ 0⤋
business center is the biggest IT market of beijing china ，i want recommend the name brand goods Clavier、Earphone、Mouse、MEMORY CARDS、Card Reader Writer to you.my website is http://www.llpshop.com ,if you have interested in ,please check it . the business MSN is :llpshop_zol@hotmail.com the business email is :llpshop_zol@hotmail.com please don't mistake this times,if break in on you ,please understanding.thank you .
2007-02-03 04:28:16 · answer #6 · answered by jianfeng 1 · 0⤊ 0⤋
http://dexter-laboratory.blogspot.com/
2007-02-01 21:41:47 · answer #7 · answered by Dexter 2 · 0⤊ 2⤋
=SUM(A1-B1)
Simple as that
2007-02-01 21:57:42 · answer #8 · answered by wally_zebon 5 · 0⤊ 1⤋