ProZ.com global directory of translation services
 The translation workplace
Ideas

 
User
Thread poster: Veronique Boulet
Excel 2002 - Is there a subtraction function?
Veronique Boulet
Canada
Local time: 01:11
Member (2004)
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


Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 07:11
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


Direct link Reply with quote
 

Kathi Stock  Identity Verified
United States
Local time: 00:11
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.


Direct link Reply with quote
 

tectranslate ITS GmbH
Local time: 07:11
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?

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


Direct link Reply with quote
 

Gianni Pastore  Identity Verified
Italy
Local time: 07:11
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.

Direct link Reply with quote
 
Veronique Boulet
Canada
Local time: 01:11
Member (2004)
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 ok

Thanks!


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Excel 2002 - Is there a subtraction function?






SDL MultiTerm Extract 2014
Save time by automatically extracting terms. Save 15% on ProZ.com

SDL MultiTerm Extract 2014 allows you to automatically create candidate term lists from your existing documentation. This removes the manual effort involved with traditional terminology creation, allowing you to rapidly add terms to SDL MultiTerm.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »