If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formulas
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. |
#2
|
|||
|
|||
Formulas
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|