Emergency Excel help!

Sephirius · Post by **Sephirius** » 2006-01-13 01:59am

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?

Braedley · Post by **Braedley** » 2006-01-13 02:44pm

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.

Post by **Ghost Rider** » 2006-01-13 04:33pm

G&C topic....off we go.

Sephirius · Post by **Sephirius** » 2006-01-13 05:11pm

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.

phongn · Post by **phongn** » 2006-01-13 07:06pm

You'd probably have to figure out the equation generated for the two curve fits and then subtract the equations.

Sephirius · Post by **Sephirius** » 2006-01-15 04:11pm

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.