Fun with excel

[JoeFahey]

I will try to describe this as best as possible, but please ask if clarification is needed.



I have a column which starts at an initial length. I need to make another column which has a certain function to give a value for each cell in its column.
This function is equal to : (The given length minus the initial length) / (The Initial length)



As some of you may have recognized, this is the function for the strain on a material. I am making a strain versus stress graph, and the stress is given, but I need to calculate the strain. I would do it row by row but I have over 3000 rows of values. For each row ground down the column I am trying to formulate, there needs to be the strain value at that time period.


Thanks in advanced!

Moved from Off Topic
moderator allisolm

 

[zzuupp]

Use the $ sign to lock down the cell reference of the initial length so that it appears as $A$1 [or whatever cell it is in]. Then just copy it all the way down.

 

[JoeFahey]

Thanks alot, it worked!