Question about Microsoft Business & Productivity Software
Quantity / total * 100.0 = percentage. You can enter the quantity and the total in different cells and then use a third cell for the calculation (such as =A1/A2*100.0) or enter data in a single cell (such as =250/1000*100.0).
Posted on Sep 15, 2014
Hi nastyguy3000;
To calculate a percentage in excel you simply take
amount/total = percentage in your cell
Example
A
B
Purchase price
Sales tax (in decimal form)
800
0.089
Formula
Description (Result)
=A2*B2
Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)
Have Fun
Mark
Don't forget to leave a rating.
Posted on Feb 19, 2009
Jan 19, 2016 | Business & Productivity Software
Sep 08, 2014 | Microsoft Excel 2010
Sep 05, 2014 | Microsoft Excel for PC
Dec 13, 2013 | Microsoft Excel for PC
Jan 03, 2009 | Microsoft Business & Productivity Software
Jun 11, 2008 | Microsoft Business & Productivity Software
Mar 25, 2008 | Microsoft Excel for PC
2,532 people viewed this question
Usually answered in minutes!
×