Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel-- negative numbers and subtracting

Posted on 1997-12-11
4
Medium Priority
?
4,562 Views
Last Modified: 2008-02-01
I'm not sure what the formula is to subtract the values of 2 or more cells.

Also, How are negative numbers processed?  I have a cell which adds two cells and divides by another.  If the number happens to be negative, then the value in the answer cell is in parenthases.  Is there a way to have it printed in the cell like regular positive numbers?
0
Comment
Question by:deeto
4 Comments
 
LVL 2

Expert Comment

by:AlFa
ID: 1605963
Change the cell format negative in brakets is a financial format you can put a personalised format like _-# ##0,00
·# Do not print 0.
·0 (zéro) print left zéros .
·? replace 0 with space
.- sign (space for +)
.+ sign (+ for +)


0
 

Author Comment

by:deeto
ID: 1605964
I don't understand what you're saying.
0
 
LVL 4

Expert Comment

by:itamar
ID: 1605965
I sugest you to always sum the cells with + (plus) sign or SUM function, e.g., SUM(A1:A2).

You have 2 ways to deal with negative results:

1. If you want to always get positive results on despite of negative values in the others cells you must use ABS function. For example:
=ABS((A1+B1)/A2)

2. If you want only SHOW negative results in the same way you show positive ones, you must format the cell in a convenient manner. How ?
Select the cell(s), right-click on the selection, choose format cells, select Custom category and type #.##0,00_);#.##0,00

If you want to take this comment as an answer, reject the previous one, so I can submit it again to be graded.

Regards,
Itamar
0
 
LVL 1

Accepted Solution

by:
Danimal earned 300 total points
ID: 1605966
Hi deeto,

 I've pasted your questions below, with some attempted answers that begin with >>>.

I'm not sure what the formula is to subtract the values of 2 or more cells.
>>>  The following formula subtracts the values of two cells from the value in cell E5

                    =E5-D5-C5

D5 and C5 are both being subtracted from E5.
Another way to do it would be

                    =E5-(D5+C5)

Both these formulas yield the same result.

As an example, say that E5=15, D5=5, and C5=3.  The result using the first formula would be 15-5-3, which equals 7.  

Using the second formula, the result would be 15-(5+3), which is the same thing as subtracting 8 from 15.  Result is 7.
---------------------------------

Also, How are negative numbers processed? I have a cell which adds two cells and divides by another. If the number happens to be negative, then the value in the answer cell is in parenthases. Is there a way to have it printed in the cell like regular positive numbers?
>>>itamar's suggestion #1 will work fine.  The ABS function stands for "absolute value."  Absolute value is the positive expression of a number.  For example the absolute value of -10 is 10.  Also, the absolute value of 10 is 10.  The ABS function in Excel returns the absolute value of the expression in parenthesis.

If these anwers don't completely make sense, please let me know, and I will try to clarify the areas that are unclear.

Good luck.
-Danimal
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question