Calculating fields

[Dave Niezabitowski]

I have a two table - EVENTS and RESULTS

In the EVENTS table there is one field - ATTENDANCE_TOTAL

In the RESULTS table there is a field POINTS_AWARDED and POSITION_FINISHED.

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

and enter the results into the POINTS_AWARDED field.

Any thoughts on how I can do this? I'm not a noob but I'm VERY close. I also need to make sure it updates if I were to change the player's finishing position.

Thanks in advance.