Formulas

[Cpirt]

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.

 

[Roger Govier]

Hi

On sheet2 set up a list with 1,2 and 3 in A1:A3 to represent your
version numbers.
In B1:B3 enter your costs e.g. 10, 15 and 20

On Sheet1 in A1 enter your sale price.
In B1 enter the Version number
in C1
=If(B1="","",A1-Vlookup(B1,Sheet2!A:B,2,0))