| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
relation between 'items' en 'prices'
Hello,
I am trying to make a Quote-spreadsheet. I have a column with items that i can choose from a list. Now I want anothor column to get automaticly the right price for that item out of a list. Do I need a formula that says if the item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and don't now how to solve this. Can anybody help me. Thanks in advance ! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
relation between 'items' en 'prices'
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Farid" wrote in message ... Hello, I am trying to make a Quote-spreadsheet. I have a column with items that i can choose from a list. Now I want anothor column to get automaticly the right price for that item out of a list. Do I need a formula that says if the item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and don't now how to solve this. Can anybody help me. Thanks in advance ! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
relation between 'items' en 'prices'
Thanks a lot ! It was quite difficult but I managed to resolve my problem.
"T. Valko" wrote: See this: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Farid" wrote in message ... Hello, I am trying to make a Quote-spreadsheet. I have a column with items that i can choose from a list. Now I want anothor column to get automaticly the right price for that item out of a list. Do I need a formula that says if the item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and don't now how to solve this. Can anybody help me. Thanks in advance ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF problems in a relation between worksheets | Excel Discussion (Misc queries) | |||
| relation equation between two columns | Excel Worksheet Functions | |||
| how can i find the relation between x & y in chart | Charts and Charting in Excel | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
| Cell relation ships. | Excel Discussion (Misc queries) | |||
Linear Mode
