Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative numbers to percent
i have a column of numbers that range from -5000 up to 150,000 and would like
to place the numbers into perspective from 0% to 100% but i can't figure it out , can someone help. -- scorpion |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative numbers to percent
What you are talking about is an index. You have a range of 155,000 and you
want to break it into 100 parts. So each part is 1550. If: a1 = -5000 (index value 0) a2 = 150000 (index value 100) To determine index value of b1, you want: =(b1-$a$1)/($a$2-$a$1) Format as percent. Regards Fred. "Scorpion" wrote in message ... i have a column of numbers that range from -5000 up to 150,000 and would like to place the numbers into perspective from 0% to 100% but i can't figure it out , can someone help. -- scorpion |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative numbers to percent
Another thought: =PERCENTRANK({-500;150000},B1)
where B1 houses the value -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Scorpion" wrote: i have a column of numbers that range from -5000 up to 150,000 and would like to place the numbers into perspective from 0% to 100% but i can't figure it out , can someone help. -- scorpion |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative numbers to percent
Hey Fred , that works perfectly.
i can't thank you enough, i'm sure glad you responded. Dan -- scorpion "Fred Smith" wrote: What you are talking about is an index. You have a range of 155,000 and you want to break it into 100 parts. So each part is 1550. If: a1 = -5000 (index value 0) a2 = 150000 (index value 100) To determine index value of b1, you want: =(b1-$a$1)/($a$2-$a$1) Format as percent. Regards Fred. "Scorpion" wrote in message ... i have a column of numbers that range from -5000 up to 150,000 and would like to place the numbers into perspective from 0% to 100% but i can't figure it out , can someone help. -- scorpion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
Negative percent formula | Excel Worksheet Functions | |||
How do I format a negative percent? | Excel Discussion (Misc queries) |