Golf Skins Game I am setting up a golf skins game. I use this formula Formula*Is

Question

Golf Skins Game

I am setting up a golf skins game. I use this formula

Formula*Is*=$A2=MIN($A$2:$A$40)

Pattern*color*yellow

when I enter the score per player to show me which ones have the lowest score on the hole. I can have two or more people with the low score, and they are highlighted in yellow. In cell A42 I want it to take the number of winners and divide them into A1 which is these skin value. Example A1 is 100 dollars, I have a total of 12 winners on hole one so I want to divide 100 by 12 and gett 8.33 but I want to round this down to the dollar amount only so shows 8 dollars. Any help is appreciatedd.

Explanation / Answer

If I understand you correctly:~

A42: =INT(A1 / COUNTIF(A2:A40,MIN(A2:A40)))

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.