excel formula help please!

  lapnutty 11:49 14 Apr 2007
Locked

hello

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
eg
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?

thanks

  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

$A$1

instead of

A1

  lapnutty 11:59 14 Apr 2007

hi

thank you.

i've found the formula but i'm not sure how it's worked!
=ROUND(MIN(A:A)/A1*10000,0).
thanks

  VoG II 12:20 14 Apr 2007

This will give you the same results

=ROUND(10000*A$1/A1,0)

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