ExcelBanter - percentages

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - percentages (https://www.excelbanter.com/excel-worksheet-functions/117695-percentages.html)

mike cooke

percentages

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 ?

Dave F

percentages

=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 ?

All times are GMT +1. The time now is 10:26 AM.