Formula Question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Formula Question

  1. #1
    Guest

    Default

     
    I need to make a formula that will look at 3 cells, then pick the cell with the highest value. Then, add the average of the other to cells to this highest value cell. How would this be done?

    Thanks,
    Eric

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,872
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-23 14:56, Anonymous wrote:
    I need to make a formula that will look at 3 cells, then pick the cell with the highest value. Then, add the average of the other to cells to this highest value cell. How would this be done?

    Thanks,
    Eric
    Is this

    =MAX(A1:C1)+(SUM(A1:C1)-MAX(A1:C1))/2

    what you want?

  3. #3
    Guest

    Default

    Perfect, thank you much!

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    LOL! And here I was struggling with *AVERAGE*.
    ~Anne Troy

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dreamboat darling hi hope alls well, im telling you Aladin is the formual guru or gurus.

    I have billions of his post saved and printed and archived, and still i everyday i scratch my head when he posts, ive got to the point i excpect it of him after watching him for a year 18 months maybe more. Ive learn so much, but still 1% of what his knowledge is, just

    just

    just

    wonderfull................. mind blowing


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And people think we come here to help, right, Jack?

    WRONG!

    We come here to LEARN!

    But what a NICE way to do it!
    ~Anne Troy

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Jack, Could you be kind enough to winzip Aladin's posts and email to me. . I also think he is greatful in Excel.


    Here to Learn
    Andrew XJ

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com