Rounding to a range

[SHalper]

I have a bunch of returns in percentage form (ie: 1.45%, 0.5%, 0.4%
-2.35%, etc) and I want to have a set a ranges and tell me how many
times a return is closest to a number. I have put an example below.

Rounded Returns and then display the number of times a return closest
to the range listed below is present. Using the numbers above:
1.5% 1 time
1.0%
0.5% 2 times
0.0%
-0.5%
-1.0%
-1.5%
-2.0% 1 time

 

[Bernard Liengme]

Have a look at the FREQUENCY function in Help.Then come back if you have
more questions.
Your numbers: -1.0%, -0.5%, 0%,0.5%,1.0%, 1.5% make up what is called the
BIN, they must be in ascending order
best wishes

 

[SHalper]

Have a look at the FREQUENCY function in  Help.Then come back if you have
more questions.
Your numbers: -1.0%, -0.5%, 0%,0.5%,1.0%, 1.5% make up what is called the
BIN, they must be in ascending order
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email







- Show quoted text -

I am familiar with that function, however, I need the results in table
format so it can be graphed showing the number of times a percentage
it the closest variable. Do you have any other suggestions besides
doing it manual?

 

[Bernard Liengme]

I would have thought he FREQUENCY output was in a table form and I know you
can make a chart of its results
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Have a look at the FREQUENCY function in Help.Then come back if you have
more questions.
Your numbers: -1.0%, -0.5%, 0%,0.5%,1.0%, 1.5% make up what is called the
BIN, they must be in ascending order
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email







- Show quoted text -

I am familiar with that function, however, I need the results in table
format so it can be graphed showing the number of times a percentage
it the closest variable. Do you have any other suggestions besides
doing it manual?