Assigning Dollar Values to 'Buckets'
 

Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) Looking foward to hearing back.
Thanks a million.

For example:
A B
$ 504.09 $ 500 - $ 1,000
$ 1,725.35 $ 1,500 - $ 2,000



--
Thank you -- Suzanne.

Assigning Dollar Values to 'Buckets'
 

=TEXT(INT(A2/500)*500,"[$$-409] # ##0")&" -
"&TEXT(INT(A2/500)*500+500,"[$$-409] # ##0")
Regards,
Stefi


€žSuzanne€� ezt Ã*rta:

Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) Looking foward to hearing back.
Thanks a million.

For example:
A B
$ 504.09 $ 500 - $ 1,000
$ 1,725.35 $ 1,500 - $ 2,000



--
Thank you -- Suzanne.

Assigning Dollar Values to 'Buckets'
 

With your first dollar value in A1, put this in B1:

=TEXT(INT(A1/500)*500,"$0")&" to "&TEXT((INT(A1/500)+1)*500,"$0")

Copy it down column B as required.

Hope this helps.

Pete

On Jul 30, 12:01*pm, Suzanne
wrote:
Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) * Looking foward to hearing back.
Thanks a *million.

For example:
* * * *A * * * * * * * * *B
$ * *504.09 * * $ * 500 - $ 1,000
$ 1,725.35 * * $ 1,500 - $ 2,000

--
Thank you -- Suzanne.

Assigning Dollar Values to 'Buckets'
 

Nice! It's a keeper. Thanks so much.
--
Thank you -- Suzanne.


"Stefi" wrote:

=TEXT(INT(A2/500)*500,"[$$-409] # ##0")&" -
"&TEXT(INT(A2/500)*500+500,"[$$-409] # ##0")
Regards,
Stefi


€žSuzanne€� ezt Ã*rta:

Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) Looking foward to hearing back.
Thanks a million.

For example:
A B
$ 504.09 $ 500 - $ 1,000
$ 1,725.35 $ 1,500 - $ 2,000



--
Thank you -- Suzanne.

Assigning Dollar Values to 'Buckets'
 

You are welcome! Thanks for the feedback!
What does "keeper" mean in this context? I never heard it!
Stefi

€žSuzanne€� ezt Ã*rta:

Nice! It's a keeper. Thanks so much.
--
Thank you -- Suzanne.


"Stefi" wrote:

=TEXT(INT(A2/500)*500,"[$$-409] # ##0")&" -
"&TEXT(INT(A2/500)*500+500,"[$$-409] # ##0")
Regards,
Stefi


€žSuzanne€� ezt Ã*rta:

Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) Looking foward to hearing back.
Thanks a million.

For example:
A B
$ 504.09 $ 500 - $ 1,000
$ 1,725.35 $ 1,500 - $ 2,000



--
Thank you -- Suzanne.

Assigning Dollar Values to 'Buckets'
 

Ah, something good, something worth holding on to and keeping : )
--
Thank you -- Suzanne.


"Stefi" wrote:

You are welcome! Thanks for the feedback!
What does "keeper" mean in this context? I never heard it!
Stefi

€žSuzanne€� ezt Ã*rta:

Nice! It's a keeper. Thanks so much.
--
Thank you -- Suzanne.


"Stefi" wrote:

=TEXT(INT(A2/500)*500,"[$$-409] # ##0")&" -
"&TEXT(INT(A2/500)*500+500,"[$$-409] # ##0")
Regards,
Stefi


€žSuzanne€� ezt Ã*rta:

Greetings. I have several hundred rows of dollar amounts in column A, in
column B i'd like to display the 'dollar bucket' this value falls into. (The
buckets are predetermined $500 increments.) Looking foward to hearing back.
Thanks a million.

For example:
A B
$ 504.09 $ 500 - $ 1,000
$ 1,725.35 $ 1,500 - $ 2,000



--
Thank you -- Suzanne.