G Guest Nov 6, 2006 #1 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 ?
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 ?
G Guest Nov 6, 2006 #2 =A1/B1 and fill down. Or =B1/A1 and fill down. Depends what is a percentage of what?