View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default 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.