Subscribe Bookmark RSS Feed

Column formula to get a particular row value

Hi Guys,

I have columns as follows:

Data1 Data1_value Data2 Data2_value
1 0.5 15 25
2 0.4 14 24
3 0.3 13 23
4 0.2 12 22
5 0.1 11 21

Now I want to make a column that will have the 60% of the highest value in all four columns something like this:

Data1 Data1_value Data2 Data2_value
0.6 0.3 9 15

Is there an easy way to do this with a script?

Thanks,