Well you will never get 1225 with this formula.
(72.7291*(10*(A4+0.24))^1.81)=94123.45116
and
(72.7291*(10*(A4+0.24)^1.81)=14577.99654
So, either the 1225 is wrong or the formula is wrong.
Miguel
Richard Hunter wrote:
>
> 50m formula for scoring indoors
> can anyone help????
>
> =SUM (72.7291*(10*(A4+0.24))^1.81)
>
> A4 is the cell for 5.0 seconds hand timed the points score should be
> 1225points
>
> this doesn't work in excel where am I going wrong?
>
> any help appreciated
>
> RH
>
> Important Information
>
> This e-mail constitutes a confidential communication
> and is subject to legal privilege. If you have received
> this e-mail in error, please notify us immediately. You
> should not use or copy it for any purpose, nor disclose
> it to any other person.