Remember Me?

#1
March 6th 10, 08:17 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2010 Posts: 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
March 7th 10, 04:44 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Feb 2010 Posts: 181
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

"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
March 7th 10, 10:36 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Feb 2010 Posts: 376
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.

#4
July 6th 21, 07:23 AM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
Data Validation + Formula

Hello!

You can go to data, then validation. From there you can choose allow list, so you can have a drop down list. You have to put your data inputs somewhere to do the drop down list, presented as a table. A drop down list will allow you to select a value from a table of values, depending on what you choose.

Next, you just have to place a value you want to deduct from your drop down list on a any random cell. For this example, we can say it as A1. Then you can build a formula on another cell, where dropdown list - A1 is the formula on another random cell B1.

Anyway for more tips on excel and financial models, you can check the page out. Hope this helps.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Pierre Excel Worksheet Functions 3 January 14th 10 05:59 PM Brand Excel Worksheet Functions 1 October 10th 09 01:01 PM Sherberg Excel Worksheet Functions 4 September 11th 07 01:34 AM Bob Sullentrup Excel Discussion (Misc queries) 0 November 27th 06 09:01 PM creativeops Excel Discussion (Misc queries) 4 January 26th 06 04:07 AM

All times are GMT +1. The time now is 11:51 PM.