Re: Calculating fields

[Dave Niezabitowski]

Peter Brawley Wrote:
-------------------------------------------------------
> > When I enter the results in the table I need use
> this formula from a spreadsheet
> >
> IF($A7-B$6*0.3<0.51,20*(SQRT(SQRT(B$6)*(B$6)/$A7))
> ,20)+20
>
> ?! Impossible to answer till you specify which
> table columns correspond to which Excel cells.

Ok, I think that I may have found the corresponding variables.

I modified the forumula a bit.
Attendance field is in the - Events table. The FINISH_POS is in the Results table. And I need the answer to this automatically entered into the AWARD field in the results table.

ROUND(IF(FINISH_POS-ATTENDANCE*0.3<0.51,15*(SQRT(SQRT(ATTENDANCE)*(ATTENDANCE-6)/FINISH_POSITION)),20)+20)

I added the ROUND because I need the answer rounded to the whole numbers. No decimals.