You are here: HomeExcelTutorials

Adding and Subtracting negative and positive numbers

Adding and Subtracting negative and positive numbers

Price: FREE

Having an issue when taking a negative number and misusing a positive number. I assume there is a formula. I have attached a copy of the form. Example. Cas, had a total for the month -\$642.55, last week, she was in the positive by 195. the total should be
(-\$642.55) - \$195 =( -\$447.55). Instead it is adding the two (even thought \$195 is a positive number) and totaling to (-\$837.55). Need a formula so that when starting with a negative number and subtracting a positive number returns a lower negative number. (as shown in illustration)
In the illustration, I manually inputed the number. Would love a formula to handle this for me!

Visit publisher's web-site: Adding and Subtracting negative and positive numbers

Category and Tags: ExcelTutorials :

Related Tutorials

Free: Yes
Tags: Excel ›

I am trying to create a formula that will allow me to add both negative and positive numbers in the same column. It appears that when I use the SUM function, EXCEL is doing the addition first and then subtracting any negative from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it. total would be 100. When I introduce a -100 anywhere within a1 to a10, I receive 800 instead of 900.

Subtracting positive amts from negative and positive from positive

Free: Yes
Tags: Excel ›

I have a problem with a spreadsheet that SOMETIMES would result in subtracting positive amounts from negative where I would want the result to show negative but only the difference between the negative and the positive. In other words, if B9 is negative and B31 is positive then I want the negative in B9 to be
reduced by the positive in B31 and reflect a negative amount (ie. -900 minus +200 = -700) but sometimes the amount in B9 is positive and B31 is positive and so then I just want B31 subtracted from B9 to reflect a positive (i.e. +900 minus +200 = +700).
I found another answer that partially works
=IF(COUNTIF(B9:B31,"<0"),-ABS(ABS(B9)-ABS(B31)) when B9 is negative but it doesn't work if B9 is positive. How do I get the second condition into the

Adding cells that are positive and not negative

Free: Yes
Tags: Excel ›

I'm sure this is an easy formula, but one I cannot figure out.
I have dollar values in column B - some of these totals are positive, some are negative.
I'd like to add a formula to the side that adds up ONLY the positive numbers to get a grand total.

Why Subtracting Two Negative Numbers Results in Positive Number

Free: Yes
Tags: Excel › Functions

I'm using Excel 2007 and ran into a problem when creating a formula that references two cells (C8 and F8) where users will enter a negative number in each cell. So for example, the user would enter the following numbers:
Cell C8 --> -4424.872
Cell F8 --> -4278.982
To subtract both numbers I created the formula: SUM(C8-F8). But the problem is that instead of returning a negative number, the result is shown as a positive number. I'm not sure why this happening. Could someone point
Thanks for the time and expertise!

Excel - Adding positive or negative numbers in a column

Free: Yes
Tags: Excel ›

How do I add only the positive numbers in a column with both positive and negative numbers?

Related Applications & Scripts

Background effect heart

Free: No
Tags: Flash › Excel Animations

Effect: movieClip that will be used in the end.
Direction: Director of effect.
Interval: interval of time in which the effect happen.
Slide: Displacement in pixels of the effect. If this value is omitted, it will take a random value between 05 and 10.
Alpha -: Percent fade that will be implemented in movieClip to each function call.
Rotation: Rotational speed of movieClip.
Inclination: Value of the inclination of movieClip. Use positive values to tilt to the right, negative to left, zero inclination to random field blank and not to use any inclination.
RandomColor: Sets the color will movieClip random. Note: Do not work with all movieClips.
SmoothMovement: Smooths the handling of movieClip.
...

ProXTestimonial: Client Testimonials Script

Free: No
Tags: PHP › Excel Quote Display

For every potential customer it is very important to know what your clients think about your product or service. By placing positive testimonials on your website you increase chances that other people will purchase your products or services. But it is very annoyning task to collect, sort and display positive testimonials. That is why you need ProXTestimonial! It will do all these tasks easily and give you many options to display random quotes.

Flip Numbers

Free: No
Tags: Flash › Excel Random Text

This display allows you to show any number with style. It is easily and fully customizable:
change dimensions.
choose how many numbers visualize.
change the background color of the numbers.
change the numbers color.
change the distance between numbers.

Veqa Image Resizer

Free: No
Tags: PHP › Excel Image Manipulation

Veqa Image Resizer is a PHP tool to resize Web images on the fly. Features 82 size presets, width/height dimensions, constrain proportions, pixels, percentage, inches, centimeters, millimeters, points, picas, adding, subtracting, multiplying, dividing, randomizing, limiting, and multiple resizing. Supports JPG, GIF (and animations), PNG, BMP; and GD, ImageMagick, MagickWand. Also provides interface, login protection, caching, cache gallery, file saving, class functions, reformatting, user documentation, and more. Resize all your images and resize your time by getting it all on the dynamic fly.
Features:
Get resized images on the fly, save files on Web server, and class functions to use in your own scripts. Supports JPG, GIF (and animations), PNG, and BMP image formats. Supports GD, ImageMagick, and ImageMagick MagickWand for PHP. Provides an interface for easier use, which also comes with login protection. Cache images for on-the-fly along with its very own cache gallery.