Question about Microsoft Business & Productivity Software
In my daily tracking excel template , i would like to add the column for percentage:
My Requirements is :
1) 1st Column in my template Total No test steps :
Ex: 700
2) Per day i have executed Ex: 200
Out of 700 steps i have executed 200 steps , so this 200 steps i have to show in Percentage in the template in separate column.
Please send me the formula to calculate the percentage in the excel
The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.
Then you can format the cell to show the number (.2857) as a percentage (28.57%).
Posted on Jan 03, 2009
Jan 19, 2016 | Business & Productivity Software
Sep 08, 2014 | Microsoft Excel 2010
Nov 17, 2011 | Microsoft Excel for PC
Feb 19, 2009 | Microsoft Business & Productivity Software
Dec 02, 2008 | Microsoft Office Professional 2007 Full...
Aug 08, 2008 | Microsoft Excel for PC
Jul 22, 2008 | Microsoft Excel for PC
Jun 11, 2008 | Microsoft Business & Productivity Software
Mar 25, 2008 | Microsoft Excel for PC
Dec 09, 2007 | Business & Productivity Software
627 people viewed this question
Usually answered in minutes!
×