+ Reply to Thread
Results 1 to 3 of 3

Changing Average Percentage While Keeping Some Numbers Constant

  1. #1
    Registered User
    Join Date
    06-26-2017
    Location
    Shenzhen, China
    MS-Off Ver
    Mac 2008
    Posts
    1

    Angry Changing Average Percentage While Keeping Some Numbers Constant

    Hi Everyone,

    I'm wondering if someone can help me in a big way. I have a current formula that looks like this =((F10×0.1)+(G10×0.15)+(H10×0.15)+(I10×0.15)+(J10×0.15))×(100÷70) But I need it to look like this =((F10×0.1)+(G10×0.10)+(H10×0.10)+(I10×0.10)+(J10×0.10)+(K10x0.10)+(L10x0.10))×(100÷70) because some genius changed our grading scale halfway through the semester. Is there any way I can keep the former numbers but randomly assign values to the extra two criteria to equal the same amount? Any help would be appreciated!

  2. #2
    Forum Contributor
    Join Date
    07-16-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Changing Average Percentage While Keeping Some Numbers Constant

    Hi Waychild - Welcome

    Try putting the 0.10 in say cell A1 and 100/70 in cell A2 the formula required is =Sum(F10:L10)*A1*A2, if A1 and A2 are occupied put them somewhere else and change formula accordingly.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Changing Average Percentage While Keeping Some Numbers Constant

    I believe that the following formula will yield the value that needs to be entered into K10 (L10 may be left blank) so that the result of the first equation equals that of the second:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-11-2015, 04:26 AM
  2. Keeping numbers constant
    By skillsguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 06:54 AM
  3. changing numbers but the keeping the others the same
    By Lcrease in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2014, 08:55 AM
  4. Replies: 1
    Last Post: 06-18-2014, 02:46 PM
  5. Replies: 1
    Last Post: 04-21-2013, 09:52 AM
  6. VBA changing Rows while keeping the columns constant
    By tmd2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2011, 04:12 PM
  7. keeping one cell constant
    By Malcolm in forum Excel General
    Replies: 1
    Last Post: 07-10-2006, 09:34 PM

Tags for this Thread

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