Question about Microsoft Computers & Internet
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
Hi,
a 6ya Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!
Posted on Jan 02, 2017
Apr 08, 2017 | Excel Computers & Internet
Jan 19, 2016 | Computers & Internet
Sep 08, 2014 | Microsoft Excel 2010
Nov 17, 2011 | Microsoft Excel for PC
Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.
Example
The example may be easier to understand if you copy it to a blank
worksheet.
Apr 30, 2011 | Computers & Internet
May 21, 2009 | Computers & Internet
Apr 16, 2009 | Computers & Internet
Feb 19, 2009 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Excel for PC
Jul 22, 2008 | Microsoft Excel for PC
666 people viewed this question
Usually answered in minutes!
×