Excel 2002 - Is there a subtraction function?
Thread poster: Veronique Boulet

Veronique Boulet
Canada
Local time: 23:36
English to French
+ ...
Feb 13, 2006

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  Identity Verified
Hungary
Local time: 05:36
Member (2002)
English to Hungarian
+ ...
minus sign Feb 13, 2006

When you use a formula in a cell, simply place a minus sign.

C1=B1-A1

regards,
Csaba


 

Kathi Stock  Identity Verified
United States
Local time: 22:36
Member (2002)
English to German
+ ...
minus sign Feb 13, 2006

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.


 

tectranslate ITS GmbH
Local time: 05:36
German
+ ...
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?icon_smile.gif

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  Identity Verified
Italy
Local time: 05:36
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.

 

Veronique Boulet
Canada
Local time: 23:36
English to French
+ ...
TOPIC STARTER
It works! Feb 14, 2006

Thank you very much, it works!
I have to do it manually - contrary to the sum function, but it is okicon_smile.gif

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?

Advanced search






SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

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 »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search