Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Excel vs Mathcad

[Subject Prev][Subject Next][Thread Prev][Thread Next]
In a message dated 8/12/99 10:42:33 PM Pacific Daylight Time, 
JPRiley485(--nospam--at) writes:

<< You can label each cell in a spreadsheet (e.g. "w", "DL", "LL", "M").  
 This works fine if you have only one cell per label.  But what if you want 
 have more than one similar calculation on a single spreadsheet? >>

You can name each of your columns w, DL, LL, M and simply write the formula 
once in each adjacent column that manipulates the data. Excel will treat the 
name a specific to the cell in that column which is on the same line as the 
cell that you are combining it with.
Example: Create a column for w, another for L. Highlight the cells in the 
first column that will contain data and name them "w" (type in the name in 
the cell reference box at the left of the toolbar). Do the same for L. In the 
cell adjacent to the L in the first row enter the formula =w*L^2/8 for a 
result. Now simply copy this cell to each cell below. The formula always 
appears with the variable names.