Another way to copy the formula - once you have the formula set, select that cell. You should have a black band around the cell, with a square dot/highlight at the lower right corner. Put your cursor ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...