=A1/B1 and fill down.

Or =B1/A1 and fill down. Depends what is a percentage of what?
--
Brevity is the soul of wit.


"mike cooke" wrote:

if i have figures in range A1 to A20 and B1 to B20 how do i easily calculate
them as percentages in C1 to C20 ?