LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Linda
 
Posts: n/a
Default calculating results in formulas

I am trying to do some calculate differences between results in columns
containing a mix of negative or postive numbers. I can't seem to write the
formula to display the results that are expected.

So far....I get the correct answer but all are postive results, and I can
add the minus sign, but then get only negative results. When summing the
answer columns results...then the difference is inflated.

For example: (0.33)-(0.37)=0.04 and 12.28-9.72=(2.56)

I would like the formula to take a negative number subtract another negative
number and display the result as a positive AND the same formula to take a
positive number and subtract another postive number and display the result as
negative.

Thanks for your help.
--
Linda

 
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
Formulas stop calculating brodiemac Excel Discussion (Misc queries) 3 November 7th 06 04:17 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
Copying options: contents, results, formulas, etc. Top Spin New Users to Excel 2 December 20th 04 04:54 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM
displaying results and not formulas Marc S Excel Worksheet Functions 2 November 11th 04 01:34 PM


All times are GMT +1. The time now is 01:18 PM.

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"