+ Reply to Thread
Results 1 to 8 of 8

percentage calculation from cumulative totals

Hybrid View

bearingman percentage calculation from... 06-04-2010, 04:37 AM
teylyn Re: percentage calculation... 06-04-2010, 04:42 AM
bearingman Re: percentage calculation... 06-04-2010, 05:04 AM
teylyn Re: percentage calculation... 06-04-2010, 05:23 AM
bearingman Re: percentage calculation... 06-04-2010, 06:12 AM
teylyn Re: percentage calculation... 06-04-2010, 08:04 AM
bearingman Re: percentage calculation... 06-04-2010, 08:44 AM
teylyn Re: percentage calculation... 06-05-2010, 06:28 AM
  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: percentage calculation from cumulative totals

    bearingman,

    you have a formula in column E. If that formula does not deliver what you want, can you please mock up the expected result manually and give a detailed logical description how the result should be achieved?

    So far, I see a formula and it's working. If it's not the result you want, describe what you want instead.

  2. #2
    Registered User
    Join Date
    12-21-2009
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: percentage calculation from cumulative totals

    teylyn
    I agree the formula seems to be working but the expected outcome seems wrong? If the target, 760, is achieved or surpassed I would expect the percentage to increase and not decrease?
    As I say it may just be a fundamental maths error or misunderstanding but I can't get my head round it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1