Question about Microsoft Excel for PC
Wat Function do I use to
let say I want to put in a surten % of mark- up
To calculate 30% of any number you want to multiply that number by 0.3
To do this in Excel, choose the cell you want the calculation to appear in and type "=X1*.3" where X1 is the cell with the list price in it. If all your list prices are in Column C, for example... and you want calculated trade prices in Column F... you could put "=C1*.3" in the first row of Column F and "=C2*.3" in the second row of Column F and so on...
If you have a long list, just enter the formula in the first row of Column F (or your selected column) hit ENTER, then position your cursor at the lower right corner of the F1 cell and you will see your arrow change to a crosshair. Now click and drag down the column to copy the formula down as far as you like.
Posted on Sep 11, 2008
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
Posted on Sep 03, 2008
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
Posted on Jan 02, 2017
Tips for a great answer:
Jul 30, 2014 | Microsoft Excel 2010
Jun 12, 2014 | Zebra LI4278 Barcode Scanner
Jul 01, 2011 | 2006 Chevrolet HHR
Apr 29, 2010 | 2003 kawasaki KDX 220 R
Nov 14, 2009 | 1990 Hyundai Excel
Aug 22, 2009 | Computers & Internet
Jun 19, 2009 | Microsoft Computers & Internet
Feb 18, 2009 | Microsoft Computers & Internet
Feb 03, 2009 | Microsoft Excel for PC
Feb 05, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
103 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: