Question about Microsoft Excel for PC
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!!
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 08, 2017 | The Health & Beauty
Sub sbVeryHiddenSheet() Sheets("SheetName").Visible = xlSheetVeryHidden End Sub
on Dec 09, 2016 | Microsoft Excel for PC
Oct 13, 2016 | poemsource.com Computers & Internet
May 26, 2014 | Miscellaneous
Nov 19, 2013 | Office Equipment & Supplies
Hope this helps. Please rate my response.
Have a good day
Dec 27, 2010 | Computers & Internet
Apr 06, 2009 | SPSS 13.0 (30960UU)
Nov 17, 2008 | Microsoft Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
353 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: