Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Become a Premium Member and unlock a new, free course in leading technologies each month.

Solved

Posted on 1997-12-11

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?

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?

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

- Help others & share knowledge
- Earn cash & points
- Learn & ask questions

4 Comments

·# Do not print 0.

·0 (zéro) print left zéros .

·? replace 0 with space

.- sign (space for +)

.+ sign (+ for +)

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

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

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …

- Document Imaging
- Microsoft Office
- Images and Photos
- Office 365
- Office / Productivity
- Photos / Graphics Software, *Office 2013, *office 2010, *Office 2016

Earn Certification

HTML5 Specialist - Certification

Free withPremium

Course of the Month9 days, 9 hours left to enroll

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