=IF(Function issues again)

[Kamkraft]

I'm trying to achieve this:

=IF(A1=1,10,A1=2,25,A1=3,45,A1=4,70) etc etc

Basically its a point scoring system, each time some one achieves a better time the score accumulates an extra 5 points on top each additional time.

1st time = 10 points / 2nd time = 15 points / 3rd time = 20 points etc etc

Thanks in advance

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[Kamkraft]

You sir, deserve a medal!!!!! Thank you