Question about Televison & Video
SOURCE: formulate Sheets for Price Analysis
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
You are on the wrong website for this type of inquiry. This is a self help website for the repair and use of consumer manufactured products..
Jun 22, 2017 | The Computers & Internet
Sub sbVeryHiddenSheet() Sheets("SheetName").Visible = xlSheetVeryHidden End Sub
on Dec 09, 2016 | Microsoft Excel for PC
on Nov 07, 2011 | Dell 2135cn All-In-One Laser Printer
Apr 24, 2015 | Amazon Kindle
Sep 29, 2014 | 2003 Honda Accord
May 22, 2014 | Cars & Trucks
Oct 13, 2012 | Samsung Televison & Video
Nov 14, 2010 | Flotec FP0S2400A-03 1/3 HP 2,500 GPH...
Sep 03, 2008 | Microsoft Excel for PC
Sep 02, 2008 | Microsoft Excel for PC
37 people viewed this question
Usually answered in minutes!
×