LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default subtract a positive from a negative

I need a formula that will subtract positive numbers from negative numbers
"and" negative numbers from positive, with the answer in the correct form,
ie; positive or negative.

All numbers refer to either a gain or loss in quantity
Row 1 values are taken from one source
Row 2 values are taken from another source
I need a formula for row 3 to give me the total gain or loss represented in
each column.

Example
A B
1 (20.5) 17 Row 1
2 1.5 (2) Minus Row 2
3 (19) 15 Equal Row 3


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Some Positive, Some Negative Marsh Excel Worksheet Functions 3 December 16th 06 08:57 PM
How to add all positive and negative numbers? Knold10 Excel Worksheet Functions 1 November 19th 05 03:02 AM
IF positive/If negative???? CadensDad Excel Worksheet Functions 1 October 14th 05 02:15 PM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM
Convert positive # to negative bgn2 Excel Discussion (Misc queries) 1 September 2nd 05 02:22 AM


All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"