Formulas
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))
--
Regards
Roger Govier
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.
|