Page 1 of 1
Emergency Excel help!
Posted: 2006-01-13 01:59am
by Sephirius
Okay, I need some help with excel, I have two curves resulting from a titration, and I wish to subtract one from the other. How would I do this?
Posted: 2006-01-13 02:44pm
by Braedley
Shouldn't this be in G&C?
Anyways, in a third column, type "=", then click the first value in the first column, then type "-", and then click the first value in the second column. The actual value should appear. Then take the bottom of that cell and drag it down so as to copy the formula format into the remainder of the cells in that column.
Posted: 2006-01-13 04:33pm
by Ghost Rider
G&C topic....off we go.
Posted: 2006-01-13 05:11pm
by Sephirius
Braedley wrote:Shouldn't this be in G&C?
Anyways, in a third column, type "=", then click the first value in the first column, then type "-", and then click the first value in the second column. The actual value should appear. Then take the bottom of that cell and drag it down so as to copy the formula format into the remainder of the cells in that column.
problem is each has it's own scale.
i.e. 4 columns of data.
Posted: 2006-01-13 07:06pm
by phongn
You'd probably have to figure out the equation generated for the two curve fits and then subtract the equations.
Posted: 2006-01-15 04:11pm
by Sephirius
phongn wrote:You'd probably have to figure out the equation generated for the two curve fits and then subtract the equations.
exactly my problem. I have 90+ points of data, so it's kinda hard.