Question about Microsoft Excel for PC

# 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???

Regards

Declan

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

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
C10*sheet2!\$B\$5
Now as soon as your the discount changes C10 will change to reflect the discount rate.

Posted on Oct 13, 2008

## 1 Suggested Answer

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

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

Tip

### 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

### 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 | poemsource.com Computers & Internet

### What is the analysis of the poem i the butterfly by christine hagion

Sibusiso and Taryn, Check the attached links, for analysis.
"I hope this helped you out, if so let me know by pressing the helpful button. Check out some of my other posts if you need more tips and info."
The Butterfly Poem Anlysis
Butterfly Analysis eNotes com
Butterfly Analysis

May 26, 2014 | Homework

### 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.
http://www.poweredessays.com/blog

Nov 19, 2013 | Office Equipment & Supplies

### 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)

### 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

### 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

### How to formulate log function with excel

Here try this link

http://support.microsoft.com/kb/214116

Nov 12, 2007 | Microsoft Excel for PC

#### Related Topics:

358 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert

Level 3 Expert