High score expression with .25 as bonus for winner

Imported from Yahoo
1

Hi
We have small club sailing and we have the high points scoring system.
It seems that the expression s-p+1 will do most of the trick. But i also wants the winner in every class to have 0.25 added to his or her score. Anyone who knows how to do that?
Best Regards Henrik Alstersjö

2

Hi Henrick,

If you use something like this as the formula s-p+1+(p=1)*0.25

If they are first then P=1 evaluates to 1 and if position is not 1 then it evaluates to 0. Therefore if p=1 then you effectively add 0.25 and for other positions nothing is added which I hope is what you want.

Regards

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 7 April 2014 12:22, alstersjo@gmail.com wrote:

Hi
We have small club sailing and we have the high points scoring system.
It seems that the expression s-p+1 will do most of the trick. But i also wants the winner in every class to have 0.25 added to his or her score. Anyone who knows how to do that?
Best Regards Henrik Alstersjö

3

Thank you very much!
Seems to be exactly what I was looking for!
Best regards Henrik Alstersjö