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: 15:28
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: 21:28
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: 14:28
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: 21:28
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: 21:28
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: 15:28
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?






Lilt
Translators like you are producing higher quality translations faster with Lilt!

After years of research at Stanford University, Lilt has introduced a revolutionary new tool that will change the way you translate. Lilt learns how you translate to give you more personalized suggestions. Be more productive today! Use it FOR FREE!

More info »
TMreserve
Wake up in the Morning and see that you have sold TMs and made Money overnight



The TM Market Place for Translators
New: Our Instant TM Download
TM owners: Upload your TMs into the online database
Customers: Analyse your text & instantly download a text-specific TM
Well over 1.2 BILLION translation units

More info »