Thread: Formulas
View Single Post
  #3   Report Post  
Old March 7th 10, 10:36 AM posted to microsoft.public.excel.newusers
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 376
Default 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.