Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEWBIE | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
newbie needs help | Charts and Charting in Excel | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) | |||
Very very new newbie | New Users to Excel |