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

Regards

Declan

Posted by on

1 Answer

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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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

Tip

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 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
https://answers.yahoo.com/question/index?qid=20080514160402AAqThS1

May 26, 2014 | Miscellaneous

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

Nov 19, 2013 | Office Equipment & Supplies

1 Answer

The problem of pro facebook hack is data analysis (?????) what is the solve?


Facebook hack is data analysis related is absolutely right. usually the support experts make resources attainable. For example, designing device displays makes hack attainable. Methods that least makes hacking are several only requires support experts functionality. However, hacking altogether is an enormous expectation discussable. Social networks are least expected to be hacked compaired to commercial or business websites. Observing that facebook is hacked is preventable though least any expectation. For example, fortifying a social network becomes a commerial venture with moneary gains attached. The experts that make facebook should ascertain the requirements from network either as commercial, business, educative or social experinces. Once ascertained makes possible either fortifying resources as delicate.

Feb 22, 2011 | Summitsoft 50 Power Programs for the...

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

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

Nov 12, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

352 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18354 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...