PPRuNe Forums - View Single Post - Spreadsheet - Help Needed Please!
View Single Post
Old 20th September 2001 | 14:45
  #2 (permalink)  
Icarus
20 Anniversary
 
Joined: Jun 2001
Posts: 382
Likes: 0
From: Intentionally Left Blank
Post

Assuming that you are using a table to store the 'last 14' entries, then use the;
TABLE/FORMULA menu item to put a formula in the 15th cell of the particular column in the table.
From the dialogue box you can enter the formula you may need to use similar to that done in Excel; i.e. AVERAGE(A1:A14).
Otherwise, why not set up a speadsheet in Excel and CUT/PASTE it into your MS Word document.
Or you could use the INSERT/OBJECT menu item to insert a (fresh) Excel worksheet into your document.
Icarus is offline