price

Hello,</SPAN></SPAN> Combine all products with different varieties to achieve a special offer price package </SPAN></SPAN> I am looking for a solution on how many special offer price packages can be prepared from the product and variety list of D5:F12, Note: there is Product A To H & Variety...

I've created a form that prints out price labels. at the bottom of the form I would like to include the barcode corresponding to the price on the form as a label.caption so lblPrice.caption = variablePRICE I would like to take variablePRICE and assign its corresponding barcode to...

I have a problem where I am trying to produce a certain number of units, however the available capacity does not allow all of the units to be produced each month and they need to be produced in order of their ranking from 1 through 6. The ranking of the units to be produced changes from month...

Hello, Let's say we have a worksheet called: Sales In this worksheet, we have 2 columns: Product, Price We want to insert into this worksheet from VBA using an SQL INSERT 1 record where the Product is "Computers" and the Price is 30. If we do this when we have some records it is ok, but when...

Im testing the following code empty excel sheet: --------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then If Target.Value > 280 Then Cells(1, 2) = 99 End If End Sub...

Hey there! So im trying to watch for a price drop on a specific phone on a specific website. I want to continue to scrape this page every 30 minutes, and paste the price into a excel sheet or google sheet. Here is the page...

Suppose I want to show the names of various named ranges in a table. In this table, for example, I have assigned the name "Price" to Column C and "Quan" to Column D. I would like to put some expression, like "=RangeName(C:C)", into C6 and D6 that would show those names and would change if I...

Hi I've three quick questions, please: 1) Is it possible to create a formula which which can search for two different numbers in a cell and IF they are the same, return a result? Eg if a cell had "3 for 3" I'd like to return the words "same numbers" 2) If a cell had two values but X was...

Hi I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell. In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1. The formula I have used is...

Hi, I'm a beginner in VBA and I'm not familiar with most of the code here. I read up on several threads about Worksheet_Change() and can't find something that suits to my need. Currently, I'm doing a project and let's assume that I changed the price of fish from $2 to $4. Sheet 1 (Original...

Hi All, any help on this would be greatly appreciated. The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet. I need the following data retrieved from this list. 1 - Total number of internet changes for each car 2 - The...

Hi all, I'm new to Excel and totally overwhelmed trying to master it. In my spreadsheet that will keep track of my stock investments, I want Column H (total profit) to subtract $10 from every answer to factor in commission fees. My formula for Column H is: =(E3-D3)*F3-10, where E3 is my sale...

I'm trying to pull pricing from a separate workbook. Not all part numbers are included in the new pricing, just the updated ones. Closest I've gotten is the formula below but I don't want a blank when false, I want the old but still current price to remain...

Hi. This is what I got, it works like I want it except for when it's to enter retail price and contractor pricing. what I would want it to do is make sure whoever enters the item and price that they enter it properly... and numbers only... so if they were to enter an item with the $ sign or...

Hello all and thank you in advance for any advice. Microsoft 2016 I have dates listed in and based on how far away the date is from today in decimal forum I need to add 2 cells together. As an example, if the item x is 6 months from now, I need to add a cell to the price shown therefore...

Hello Everyone, Could someone let me know if there is a way to add the results of a calculation into the comment for a selected range? if so, could the results in the comment change if any of the values change? GM% Formula:(Customer A Price - Cost) / (Customer A Price) <tbody> Cost Customer...

I have a spreadsheet with products and prices. I need in my sales spreadsheet that if the product name is B the price is C, if the product name is D the price is E etc. I have around 80 products. I have tried all the way possible with the IF function but cannot make it work. Thanks

workbook "invoice" column A has item numbers. workbook "price" column A has item numbers and column H price (should have price) if H does contain the price then place that info in H "invoice" ... then continuing the fill-in process until last row if the H doesn't contain a price, continue same...

Hello guys, Would appreciate some guidance. I have three sheets named "check", "current" and "previous". Column description in all sheets are B= product number, C= purchase price, D= sales price. "Current", values: B3= 77, C3= 100, D3= 150 "Previous", same values appear on a different row...

<tbody> Area Price Discount 1 Discount2 Net price A 100 20.5 3.78 79.5 B 100 15.7 2.95 84.3 C 100 11.3 1.87 88.7 A 20.5% 4.75% B 15.7% 3.5% C 11.3% 2.105% </tbody> Please help to make single formula in Net price column for example in E2...