The excel formula for percentage is Portion Days Total Days 100. It is split into two parts one is 10 days in hometown and 5 days in the USA. The math to determine a percentage is to divide the numerator the number on top of the fraction by the denominator the number on the bottom of the fraction then multiply the answer by 100.
The COUNTIF and COUNTA functions can be combined to get the percentage of a specific value in a range of data in Excel.
If you are using Excel for the web click Home Number Format Percentage. Since we have a number mixed with text Excel will treat the entire cell as text. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. In cell B3 divide the second years sales 59863400 by the first year 48500000 and then subtract 1.