Thanks:  0
Likes:  0

1. 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. 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. Perfect, thank you much!

4. LOL! And here I was struggling with *AVERAGE*.

5. 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

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

WRONG!

We come here to LEARN!

But what a NICE way to do it!

7. 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

#### Posting Permissions

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