LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default Simple (maybe) percentage forumla

I have a forumla I want to calculate.

There are three cells that have a total percentage possible of 100% just adding them creates results different from what I'm wanting. Here is an example:


F5 = -30%
F6 = 35%
F7 = -35%
F8 =sum(F5:F7) and it reads -30%

What I would like for it to read is -65% to show that out of a possible -100% to 100% the total was -65%

Does that make sense? If so how do I accomplish this?
 
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
Trouble with simple percentage formula moushia New Users to Excel 3 February 28th 07 01:56 AM
Forgotten a Simple Forumla - Is Text present in another column samprince Excel Discussion (Misc queries) 3 August 4th 06 04:22 PM
Need help, simple math...from a percentage cfiser Excel Discussion (Misc queries) 2 November 17th 05 04:50 PM
Very simple percentage problem News Account New Users to Excel 8 June 29th 05 10:35 PM
Forumla to calculate a percentage julie regan Excel Discussion (Misc queries) 0 January 20th 05 07:53 PM


All times are GMT +1. The time now is 06:14 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"