Bonus points for a max value in a range of cells

[Yoti14]

I'm trying to find a max value within 4 cells and then award bonus points for highest.

The max value in BD19:BD22 should then result in 5 points in BE19. since the results will be different everytime, thats why I'm looking for a formula to produce this result.


example of what it should look like when done:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]BD[/TD]
[TD="align: center"]BE[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]FINISHES[/TD]
[TD="align: center"]BONUS[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]


Is this possible to achieve?

 

[Aladin Akyurek]

What if we have two or more instances of the max value?

 

[Yoti14]

all awarded the same bonus points then. (5)

 

[Rick Rothstein]

Put this formula in cell BE19 and copy it down to cell BE22...

=5*(BD19=MAX(BD$19:BD$22))

 

[Aladin Akyurek]

In Be19 enter and copy down:

=IF(BD19=MAX($BD$19:$BD$22),5,0)

 

[Yoti14]

THANK YOU both of you! That worked perfectly Much appreciated. Now all I have to do is solve a Auto sort issue and I'm almost done.