# Excel 2002 - Is there a subtraction function?

Excel 2002 - Is there a subtraction function?

Veronique Boulet
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

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

Csaba Ban
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

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

Kathi Stock
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:

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.

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

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?

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

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

Gianni Pastore
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.

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

Veronique Boulet
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 ok

Thanks!

 .tooltipX { position: relative; display: inline-block; } .tooltipX .tooltiptextX { visibility: hidden; width: 120px; background: linear-gradient(#1CA19F, #016B6A); color: #fff; text-align: center; border-radius: 6px; padding: 5px 0; position: absolute; z-index: 1; top: 125%; left: 50%; margin-left: -59px; opacity: 0; transition: opacity 0.3s; } .tooltipX .tooltiptextX::after { content: ""; position: absolute; bottom: 100%; left: 50%; margin-left: -6px; border-width: 5px; border-style: solid; border-color: transparent transparent #1CA19F transparent; } .tooltipX:hover .tooltiptextX { visibility: visible; opacity: 1; }

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?

TM-Town

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.

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!

P.O. Box 903
Syracuse, NY 13201
USA
+1-315-463-7323
ProZ.com Argentina
Calle 14 nro. 622 1/2 entre 44 y 45
La Plata (B1900AND), Buenos Aires
Argentina
+54-221-425-1266
ProZ.com Ukraine
6 Karazina St.
Kharkiv, 61002
Ukraine
+380 57 7281624