Excel 2002 - Is there a subtraction function? Thread poster: Veronique Boulet
|
|---|
Good Morning,
Does anybody knows if there is a Subtraction function in Excel? I am able to use the Sum function, but I would like to know if subtraction function exists and how to do it.
Thank you!
Véronique
| | | | Csaba Ban 
Hungary
Local time: 04:31
Member (2002)
English to Hungarian
+ ...
When you use a formula in a cell, simply place a minus sign.
C1=B1-A1
regards,
Csaba
| | | | Kathi Stock
United States
Local time: 21:31
Member (2002)
English to German
+ ...
As far as I know, there isn't any auto funtion as the SUM function.
To add or to subtract numbers manually:
Add or Subtract Two Numbers
In a new column, select the cell in the first row with data, type:
=
Click on the cell in that row with the first number:
+ (for addition) or - (for subtract).
Click on the cell in that row with the second number.
| | | | | Formulas in Excel | Feb 13, 2006 |
Kathi Stock wrote:
As far as I know, there isn't any auto funtion as the SUM function.
Unsurprising, isn't it? I mean, the sum or product of several arguments is always the same, but how is the poor computer to know which figure(s) to subtract from which?
Anyway, you can just start entering a formula in any Excel cell by typing = followed by a list of numbers separated by operators, i.e. =3*5+5-6/2 yields 17. You can even use cell contents in your formulas, i.e. if cell A2 contains 35, the formula =A2/7 would yield 5. Welcome to the wonderful world of Excel!
B
| | |
|
|
|
Gianni Pastore
Italy
Local time: 04:31
Member (2007)
English to Italian
| Maybe I am wrong, but... | Feb 14, 2006 |
...why not inputting the value you want to subtract with a minus (-) sign in front of them? This way you can still use the sum formula and get the job done.
| | | |
Thank you very much, it works!
I have to do it manually - contrary to the sum function, but it is ok
Thanks!
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Excel 2002 - Is there a subtraction function? | TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
