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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett