Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How to take 3 values find the lowest and than add a name

by barrysharp Apr 19, 2007 8:59PM PDT

I am making a spreadsheet to keep golf scores for me and two of my freinds. I have average scores for each player, what I want to do is on a summary page look at the averages for hole 1 find out which player has the lowest average and have his name appear on the cell.

if there is only two players I can do this using =IF(O12<O55,"Barry","Frankie")

But I just can't work out how to do this for 3 cells.

HELP!

Discussion is locked

2 Posts

- Collapse + Expand Details

- Collapse -

Re: Excel formula

by Kees Bakker Apr 19, 2007 9:40PM PDT

Use the min-function to get the highest value of the three.
Then a nested if: if it's Barry's then it's Barry, else if it's Frankie's then it's Frankie, else it's Johnny.

Very doable with 3, even 4 or 5. But not the right solution with 10 or 20. Then use a vlookup-function in a table you make for this purpose.

Note that all solutions fail if 2 of the 3 have the same average.

Hope this helps.

Kees

- Collapse -

Thanks

by barrysharp Apr 22, 2007 7:01PM PDT

Thanks I will try that out.

Back to Office & Productivity Software forum