The excel formula for percentage is Portion Days Total Days 100. Take the above data for example you can quickly find the percentage of a specific option with following formula. To quickly change the cell format to show values as percentages in Excel go to the Number group between Alignment and Styles on the Home tab.
So revenue has been decreased by -1575 from 2008 to 2009.
Percentage of Days spent in Home Town 10 15 100 6666. Right clicking on the selected cell and from the right-click menu selecting the F ormat Cells. Method 2 - Percentage Formatting Through the Format Cells Dialog Box. First Excel will calculate the formula 1-C2.