lapnutty 11:49 14 Apr 07
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 07

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

A1

lapnutty 11:59 14 Apr 07

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 07

This will give you the same results

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

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…