excel formula help please!

  lapnutty 11:49 14 Apr 2007


i'm in the middle of a psread sheet and i'm stuck with a formula!
the spreadsheet is to give points based on their relation to a winning time in a competition
winners time 2min converted to 120 seconds successfully with [m] so 120 gets 10000 points however i'm having difficulty with the remianing times
eg 130 seconds should have 9231 120/130*10000
145 8276 120/145*1000

when i try to auto fill the formula it all goes wrong and caclutates from the cell above not the original cell!

how do i get it right?


  VoG II 11:53 14 Apr 2007

I don't understand what you are trying to do but I think that you need to use an absolute reference for your 'original' cell. For example


instead of


  lapnutty 11:59 14 Apr 2007


thank you.

i've found the formula but i'm not sure how it's worked!

  VoG II 12:20 14 Apr 2007

This will give you the same results


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017