ExcelBanter - Please help Newbie

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

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

- - Please help Newbie (https://www.excelbanter.com/excel-worksheet-functions/184790-please-help-newbie.html)

Bblatz

Please help Newbie

Hello,

I have a column of numbers and I need the function (in the column beside it)
to find the lowest number and then divide that number into each value of the
column and mulitply by 100 to obtain the percentage. Any help is appreciated.

BB

Pete_UK

Please help Newbie

Try this in B1, assuming your numbers are in the range A1:A100:

=A1 / MIN(A$1:A$100)

Format the cell as percentage, and then copy down.

Hope this helps.

Pete

On Apr 23, 9:05*am, Bblatz wrote:
Hello,

I have a column of numbers and I need the function (in the column beside it)
to find the lowest number and then divide that number into each value of the
column and mulitply by 100 to obtain the percentage. Any help is appreciated.

BB

All times are GMT +1. The time now is 07:56 AM.