One way, though you don't really give very much information:

=50 - x * MAX(0,A1 - TIME(0,27,0))

where x is a factor that determines how fast points are lost.


In article ,
kevc123 wrote:

hey, i am trying to make a spreadsheet for work and i need some help

what it is for is working out orienteering scores based on time, for example
if the fastest time was 27mins they would score 50 points and then the points
would go down as the times went up