You can quickly calculate all the numbers in a column by the same percentage using the same formula with a few extra steps. C6 C11. Now to convert them into percentage select the cells and press CTRLSHIFT.
Percentage of Days spent in USA 5 15 100 3333 Percentage of Days spent in Home Town 10 15 100 6666.
P V 1 V 2 P is the percentage V 1 is the first value that the percentage will modify and V 2 is the result of the percentage operating on V 1. Operating profit margin Operating profit Total revenue In this case we obtain. To use the format 92 that is one decimal place instead of 9 choose the Increase Decimal icon. The result is the gain or loss.