2highest values from a row

[Guest]

Hi, i have a row of data in numerical form. i.e.

32,49, 85, 40, 28, 50........

How do i input the formula
-to extract the 2 highest scores, and
-multiply each of the score by 0.5
-and sum them?

Much thanks in advance.

 

[Frank Kabel]

Hi
try
=SUM(LARGE(1:1,{1,2}))*0.5

 

[Aladin Akyurek]

What if you had...

32, 49, 85, 40, 28, 50, 50, 50

Is it

85*0.5+50*0.5

or

85*0.5+50*0.5+50*0.5+50*0.5 ?