price

Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this? What I've tried so far is creating pivot tables and grouping by Production year, Category...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

I have a table of items that are assigned a fixed cost. Example: Item) Name) Price 1) Red Ruby Shirt) $35.22 2) Blue Tuxedo) $47.90 On a separate sheet I have a UserForm with a list box that grabs the table from the other sheet. I would like...

Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...

Hello, I have a table that contains 5 different groups of items. Each of those items have a price, on a separate reference table. I am trying to determine the total price of each group using a formula. <tbody> A B C D E 1 ITEM 1 ITEM 2 ITEM 3 ITEM 4 TOTAL PRICE 2 apple...

Hello All, I need help on getting SKU value of duplicate/same items sourcing from different Suppliers with best price in the column F. Col # Title Column A Supplier Name Column B SKU Column C Model # Column D Count of Model# Column E Price After...

Good Morning, I have two spreadsheets: 1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought 2. Is a file that has some information in, but has lots of missing data. I want to use file 1 to populate file 2...

I am wanting to return all records in an Access table that meet a query criteria. The query I have built via VBA code is - SELECT ID, Price, QtyOut, ValueOut, InStock, ValueInStock, Allocated FROM GoodsIn WHERE Item = '9oz Squat Plastic Cup' AND DateIn <# 22/08/2019# AND Allocated = False ORDER...

Hello all, I'm trying to find the last value in a column that is greater than one. I've got a bunch of columns each with 110 rows of expense data. Each column is a different product type, and each row is a date of the price. Some dates have a zero for the input, as there was no charge on that...

<tbody> remaining Old Contract Credits 10 Price 30 New Contract Credits 50 Price 25 Out of contract (no credits) Price 35 Remaining Credits 60 </tbody> Order <tbody> order 1 number of books order 2 number of books order 3 number of books Book 1 2 2 2 book 2 3 40 0 book...

Hello all! I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow. I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the...

Good morning everyone, can anyone help please as Im having a Real brain fog day! My if statement is =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4))) which is not returning the value expected and I cannot work out where I have gone wrong. Column info C=price 1, D=price 2,E = sum of qty received 1...

Hello, Looking for some advise on the the best method for accomplishing this task. I'm working on a project that involves pricing. We want to be able to analyze some pricing, but to do so, I need to transpose multiple lines of data into one line. Here is an example of the data. Customer -...

I wanna copy rows number 2 and then 9,16... (i+7) from sheet "daily price data" and paste them on sheet "weekly price data" can any body help me on this VBA code?

Hi, I'm not sure if i have the correct title on this thread, here is what i am trying to achieve. I have 4 shipping templates. 1. Flat Rate Envelopes 2. Small Box 3. Medium Box 4. Large Box I also have an excel sheet that has products, each product has one of those shipping methods above...

Hi, I have done a lot of searching everywhere and came up with a few different ways of doing this, but the final formula that started working for me needs help. Here is what I need: I can only export the data i need from a price field ie: 0.00 due to the limitations of the program I use. A...

Dear Forum I have a table of data; Columns G to M. This range contains prices, however some columns have no prices so are blank I have added conditional formatting to highlight the lowest price using the Min function, however this highlights all of the blank cells I have tried to correct...

<tbody> A B C D E F G H I J K L M N 1 Price 2017 Price 2018 Price 2019/01 Price change Price 2019/02 Price change Price 2019/03 Price change Price 2019/04 Price change Price 2019/05 Price change Price 2019/06 Price change 2 20 22 23 4.5% 25 8.7% 25...

Tried formatting the column to Text, Numbers, General, Currency but cannot seem to remove the spaces https://ibb.co/kQXF4GV Both columns are aligned to the left and have spaces in front of them. <tbody> Worksheet Formulas <thead>#DAE7F5[/URL] "] Cell Formula </thead><tbody> #DAE7F5[/URL] "]J2...