If your build cost is in A1, your sell price is in B1 and your profit margin
is in C1

In C1 input

=(b1-a1)

Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Cpirt" wrote:

How do I create a formula that would alow me to select a value in one cell
and subtract it from a value I enter in another cell.

IE a product with 3 versions cost me 1.00, 2.00 or 3.00 depending on the
version

I want to create a forumla that alows me to select one of the build costs
then enter a selling price in another cell and the 3rd cell would subtract
the value of the build cost from the sales price and give me my margin.