Question about Microsoft Excel for PC

1 Answer

Formulate Sheets for Price Analysis

Can you tell me how to formulate sheets for Price analysis or can you send me an example of Prformatted sheets.

I work as a Materilas buyer and this is a fast way for me to analise costs between different supppliers but the same products .

Firstly I must imput the list value and then calculate the discount price but sometimes like today I asked a supplier to send me a price list which was in Excel but already preformated to the following.

It was a workbook which contained two worksheet.

One the first was a introduction and a cell to enter my company discount whic is 30% of list Price so enter 30% in this Cell.

Then on the second sheet was full list of Materials with List Prices less my 30% which gave Trades Prices as well.

I found this a very good method but would like to know what formula lie's behinh the two sheets to construct my work in this way.

So for example if I entered 25% instead of 30% in the first Cell my Second sheet would calculate the discount in this way.

this is helpful for a number of reasons because the Suppliers discounts change as you Purchase more and would be able to keep track of data more easily.

If you cannoit understand what I mean, I can forward you the link for the Suppplier and maybe we can go from There???

Please help.........This would make my day so much easier!!



Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 82 Answers

This achieved like this.
In sheet one there is cell where you input discount percentage say for exaple it cell B5. Now this cell needsto formatted to percentage(click location B5 and then right click and select format cell .On number tag select percentage). Also in cell C5 put 75 and it will write 75% as it formated to show percentage.
Let us look at one product and then you can apply the same principle to all products.
Go to sheet2. This will contain full price in one cell and discount price.Let us say full price is in location B10 and you want the discounted price in C10.
Now if the discount is 30 % then obiously you are paying 75% of full price.
To display discount price in sheet2 at C10, you need to enter this formula in C10
Now as soon as your the discount changes C10 will change to reflect the discount rate.

Posted on Oct 13, 2008


1 Suggested Answer


6ya staff

  • 2 Answers


Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

3 Answers

Can anybody suggest a reliable soccer match analysis website for betting purposes?

One of the most dependable soccer match analysis website over the internet is I have been closely following this Korean based website lately and the analysis and prediction of important soccer matches it posts daily have been accurate most of the times. includes various statistical parameters in their Sports analysis like skills of the players, tactical formation, probable lineup, chemistry between teammates and opponents, past history and much more to accurately predict the winner. You will even get videos with every match analysis blogs for a better understanding. I have benefitted immensely from this website and winning big by placing wagers by relying on their in-depth analysis and prediction.

Apr 02, 2018 | Cars & Trucks


Excel- Unhide All Sheets

Advanced Hide Options

When we hide worksheets using, still user can right click on tabs and un-hide the worksheets. For example, following example will hide the worksheet and user can un hide the sheets on right click on sheet tabs:
Sub sbHideSheet() Sheets("SheetName").Visible = False 'OR Sheets("SheetName").Visible = xlSheetHidden End Sub What if you do not want to permit users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in un hide worksheet dialog list.
Sub sbVeryHiddenSheet()
Sheets("SheetName").Visible = xlSheetVeryHidden
End Sub

on Dec 09, 2016 | Microsoft Excel for PC

1 Answer

What are the grammatical analysis n the poem the send-off and the rear-guard?

I don't know how to do grammatical analysis on poems. This is complicated task. Better search how to buy a paper online and have it done for you. I mean academic writing services.

Oct 13, 2016 | Computers & Internet

1 Answer

What is critique and Where can I find a good examples of it?

A critique is simply refers to an evaluation and analysis of the text. That should be the critique definition. But it is noteworthy that it does not mean a negative analysis of the text. I found the best critique ever written is in the powered essay? DO you know about it? Find more here.

Nov 19, 2013 | Office Equipment & Supplies

2 Answers

Constants/missing correlations in SPSS

If all values for a specific "dummy" variable are identical, then you should delete the variable, because it adds NO information to your analysis.

If all values for one "dummy" variable MATCH the values for another "dummy" variable, then the two variables are 100% correlated -- remove one of them from your analysis.

Apr 06, 2009 | SPSS 13.0 (30960UU)

1 Answer

Explain brief about Goak Seek Command, Solver, Sceanerios

Goal Seek Solver and Sceanerios are a Part of What if Data Analysis Tools.
Goal Seek find the Expected Change in terms of value to a calculated Items.
For Example if you have a sales data for the year 2007 where Profit is 350000 and you want to make it 500000 for the year 2008 so what changes you will do in Product cost or Product Price this you will find with Goal Seek. It is also known as Back calculation. It has some restrictions which is overcome by Solver. But before doing this type of calculation use Sceanerios to store different Calculated values using Goal Seek and Solver. You dont have to add these values in different sheets all the values stored as a sceanerios. so You can show different Predections to the customers without moving around the Sheets.

Nov 17, 2008 | Microsoft Computers & Internet

2 Answers

Help I dont know mutch of excel

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

1 Answer

How to formulate log function with excel

Here try this link

Nov 12, 2007 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

374 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers


Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides