=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.