English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I am trying to subtract one value from another, I know the adding one, you simply do the "SUM.." but how do you subtract?

2007-02-26 15:07:37 · 4 answers · asked by Anonymous in Computers & Internet Software

4 answers

Example
cell A1 is 12
cell A2 is 10

so in cell A3 =a1-a2 once you hit enter it will show the result not the formula.

2007-02-26 15:11:42 · answer #1 · answered by tarnefar 2 · 0 0

There is no speacial function for substraction as you do not know in the range which is less than the other. All you need to do is to

example:
=A1-B1

2007-02-26 15:13:09 · answer #2 · answered by Udayan C 3 · 0 0

you can just type it out. in the cell you want the answer, just type "=a1-a2" or whatever cells the data is in.

2007-02-26 15:10:41 · answer #3 · answered by eriq p 4 · 0 0

= A1 - A2
check other formulas at
http://www.homeandlearn.co.uk/ME/mes5p1.html

2007-02-26 15:11:44 · answer #4 · answered by Pachecus 2 · 0 0

fedest.com, questions and answers