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.