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

Veronique Boulet
Canada
Local time: 21:54
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: 03:54
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: 20:54
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: 03:54
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: 03:54
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: 21:54
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






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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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