microsoft excel - Auto populate based on a price list - Super User
Feb 27, 2017 · I have a price list on a worksheet that has columns as follows TYPE - ITEM - JOB COST - PART COSTS - PROFIT On a second sheet (job log), when i select the 'item' from a …
Need to update pricing in a spreed sheet from a separate sheet.
Jul 13, 2016 · The new data is in a separate sheet 'New Price Data' with Product Code in A1-A1409 and Price in B1-B1409. The Product Codes in 'New Price Data' are in numerical order …
microsoft excel - How to auto-populate the rate/charges of a price …
Aug 30, 2019 · For example if you were to change the unit price to .85 the calculation would change accordingly. If you'd like every price in the column to be .75, you can Copy/Paste it …
How to get product's price based on latest date in Excel
Jan 19, 2020 · The first column of the above table is "Product Name", the second column is for the "Date" in which the prices were updated and the third column represents the price of the …
How do I assign values to items/products in Excel? - Super User
Jul 4, 2019 · How do I assign monetary values to specific products in a spreadsheet? For instance, one column would have apples, oranges and bananas, but each of these has a …
microsoft excel - How can I set up 'multiply if' logic? - Super User
Mar 16, 2022 · For each customer, I want to check which products they bought then multiply by the price list number to get how much each customer spent on each product. So the logic is: if …
Excel: change formulas based on value in drop down list
Mar 8, 2021 · My idea is, that the calculation would change based on the month I would like to calculate, which would be selected in some form of drop down list. Is it possible to tell Excel - …
Calculate different discount levels in Excel - Super User
Jul 30, 2013 · I have to create a price list with 3 different discount levels called eg. E1, E2, E3. E1 = 10%, E2 = 20% and E3 =30% discount. How do I write a formula to tell Excel if the item falls …
Excel calculation based on user input from dropdown fields
0 We are using Excel 2003 but can upgrade if necessary. We need to compute (or lookup) a value based on two inputs. Both inputs will be Excel dropdown boxes. The first one will have values …
microsoft excel - How to make a cell return a number if in another …
Jun 19, 2023 · Depending on the width of the product, the aquisition price changes. How can I make a cell where I input a width (in numbers), and depending on the range that that number …