Formula Question

[Guest]

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

 

[Aladin Akyurek]

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?

 

[Guest]

Perfect, thank you much!

 

[Anne Troy]

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

 

[Jack in the UK]

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

 

[Anne Troy]

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

WRONG!

We come here to LEARN!

But what a NICE way to do it!

 

[Andrew XJ]

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