price

Hi All, I have the data of Product in Row A and its price in row B. Similarly Product in Row C and its price in row D. in Total having 3 list of products and prices. Maximum 10 entries user can enter in each row. I want all the products from those 3 rows in single row G and its price in H...

Hi All, I need a Excel formula to calculate my selling price based on a predetermined profit. What is know is: 1) The final profit after all the cost ($20) 2) The item cost 3) The merchant fee which is 10% (0.10) 4) The payment processor fee which is 2.9% + $0.30 5) The shipping material cost...

Greetings, I am creating a spreadsheet, tracking my stock performance. I would like to have the cell color change automatically to red or green depending on whether the stock price went up or down. I am putting in an up or down arrow within the same cell as the stock price, using the Alt 24...

Hi folks, I'm not sure if this has been posted before or if there is a guide on how to do this on this forum, so apologies if there is. I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my...

I know this is simple IF solution, but haven't had to us it in a long time. I need a formula to pull the unit price from another sheet in the same workbook, based on column B and C. I have a tab in my workbook called Product List. It has Size in Column A, Discrition in Colomn B and total item...

Hello I want if there is a change in price it should reflect in new records only but should not disturb the previous records with old prices. a link of my file in the drop box is given below. https://www.dropbox.com/s/uq3fyn1snj1ah5y/salarzai%20petroleum.xlsm?dl=0 Password for opening/...

Hello, thank you for taking time to read my message. I need some help, and after searching, I dont seem to find the answer. Hopefully, I can find help here. The goal is to sum revenue based on a average sales price per item. I want to group this sales based on price point to learn the...

Hi all, Hi all, Pretty to power BI charting and eager to learn and be involved in the community =) First i will show what i did previously using powerquerry and pivot chart in excel 2016 and then i show where i am stuck in powerBI Basically i have a simple table querry from SQL...

<colgroup><col span="7"></colgroup><tbody> Hi Everyone I am trying to make this workbook fully automated as the user is not Excel savvy. Also, I am still learning to code so much of what I have here is by "Record macro" I have two problems I was hoping to get help...

Hi there I have a four product code (i.e r,p,E,Y)in cell range A1:A4 and the price for that product is mentioned against each code in cell range B1:B4 (i.e 6.87, 9.18, 10.54, 22.73). I am seeking for a formula for following purpose if i enter multiple codes in a single cell (say Er,Yp,EY, EE...

Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...

I have a substitution question. I want to substitute a vlookup into my formula. Here is the formula: =IF($D4="Code not found",0, IF(('2012 price changes'!$N$3:$N$2863)="None",0,ROUND(IF($A$2="NO",IF($E4="pkg", ROUND((IFERROR(LOOKUP(1E+100,SEARCH(" "&$A4&","," "&list01&","),(""&('2012...

Good afternoon, Excel gods. I got another question. I have a little under 700 items that I receive bi-weekly price changes. I have set it up as pictured. Is there any way to print a flash report showing only price changes? Like shown in the second image. Thank you so much for your assistance.

Hello all, I was wondering if it is possible to create an if statement that does different things depending on how many decimal places appear in a number? For example if I have the numbers 27.23 and 30.496 can I do an if statement that multiples 27.23 by 4, but multiplies 30.496 by 5? What I...

I have a list of properties in a Pivot table and want to have it so its like A Real Estate website where you choose between certain price points. Slicers dont really work as there are over 25 price points. I have done some research and there doesnt appear to be a kind of timeline for just values...

Hi everyone, I've been racking my brain and many google searches later and have been having a really hard time at this. I would really appreciate some assistance! I've got a file that has a layout like this: <tbody> Product Country 1 Product Country 2 Product Code 1 Product Code 2...

The following table in PBI has price changes. I want to get a table of a) monthly date-wise weighted average price. maybe i could create a table in PQ for each date in calendar and then group. But how do i do in DAX, since there are many materials. b) simple average by material with considering...

Hi there, I have 3 tables with codes and prices (codes are not formatted like the below). I want to enter a value in J2 and if that value is in any of the tables I want the PRICE for that table to display in K2. I can do it for two tables where it displays one value or the other using...

HI Guys/Girls I need to change my formulas and/or lookup table structure to calculate a new fee structure bring implemented in July by eBay. I need to determine multi-level value fees from a table of fees for a given value. Reader background info If you look at the Research Tab This is used...

Hy Everybody, I am sure somebody can help me: I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro. I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale My Question is, how can i make...