The Student Room Group

Anyone good with Excel? (Division with tables)

I currently have two rows (Strain and Force) and I want to find the corresponding stress for the forces (add another row for stress). The cross-sectional area is given (A = 25pi/4) but there are over 600 values so I would like to know how to make Excel do this for me automatically?

Thank you
Original post by WHEREDAOPPS
I currently have two rows (Strain and Force) and I want to find the corresponding stress for the forces (add another row for stress). The cross-sectional area is given (A = 25pi/4) but there are over 600 values so I would like to know how to make Excel do this for me automatically?

Thank you


WHat's the formula to calculate stress from the values you have?

It should be simple to set it up an excel formula

Quick Reply

Latest