Bond Chart
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Bond Chart

  1. #1
    Guest

    Default

     
    Any Ideas on how to set up a bond chart to determine the cost of a bond when there is a different rate for different dollar increments? for ex my rate is .014 from $0-$500,000 then .007 from 500,001 to 1,500,000 then .006 from 1,500,001 to 5000000 etc etc etc

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    North Alabama, USA
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Well a good start would be HLOOKUP or VLOOKUP. I use the HLOOKUP to find pricing. Our pricing is based on the quantity purchased (and a few other things). So the first column has 999 and the price covers anything less than 1000. The next column has 2499 and covers 1000 to 2499. It turns out that only one quantity is necessary. Excel will return the correct data as long as the values are sorted.

    :HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
    : Example "=hlookup(1250,B1:F1,2,FALSE)

    Search B1 to F1, return the value from second row down, and approximate match is fine.

    HTH get you started,
    Rocky...

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com