Assigning Dollar Values to 'Buckets'

[Suzanne]

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

 

[Stefi]

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


„Suzanne†ezt írta:

 

[Pete_UK]

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

 

[Suzanne]

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

=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

 

[Stefi]

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.

=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

 

[Suzanne]

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

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.

=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