+ Reply to Thread
Results 1 to 3 of 3

Get the missing number in average

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    JK
    MS-Off Ver
    Excel 2010
    Posts
    17

    Get the missing number in average

    Hi, is there a way to find the missing number from a set of numbers (2 in my case) that forms a given average.
    e.g. i have average value 10, one of the numbers is 4 and the function should return 6, if i have a number 3, the function should return 7 etc.
    Thanks

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Get the missing number in average

    The average of 4 and 6 is not 10. If your average value is 10, and one number is 4, then the other number is 16.

    (4 + 16) / 2 = 10

    (4+x) /2 = 10

    4+x = 10 x 2

    4 + x = 20

    x = 16

    (Average * Count of Numbers) - Known Numbers = Missing Number

  3. #3
    Registered User
    Join Date
    10-02-2012
    Location
    JK
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Get the missing number in average

    wow, apologies for my math, i spent so much time trying to figure out how should i do it with a function that i totally blurred.
    Many many thamks

+ 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. [SOLVED] Find missing number and copy only missing number to another coloumn
    By vijaynadiad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2013, 02:01 PM
  2. [SOLVED] Find Average, Return Column Header of Number Closest To Average
    By djmyers in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-07-2013, 04:19 PM
  3. [SOLVED] Quartile/Average/Median In Array With Missing Data Points
    By splendidus in forum Excel General
    Replies: 10
    Last Post: 05-14-2012, 09:51 AM
  4. Weighted average - what am I missing here?
    By asburytl in forum Excel General
    Replies: 0
    Last Post: 03-15-2012, 02:11 PM
  5. Calculate weighted average with missing values
    By Deiseman in forum Excel General
    Replies: 9
    Last Post: 06-08-2010, 10:03 AM

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