I prepare construction estimates and am required in some cases to add costs for providing a performance bond. I arrive at a total price lets say $1,000,000 then add in bond cost at $10 per thousand (10,000). If am successful i receive a contract for 1,010,000 from my customer. When i go to my bonding company to purchase my bond they charge me based on the total contact amount, the bond costs me 10,100. So you see i am 100 short from what i included in my estimate. This doesn't seem like a big amount but when you get to much larger projects it can be significant. At first glance this could be done by turning on creating a circular reference and turning on iteration. I am wondering if there is any other way of doing this which doesn't create a circular reference.
Thanks for your help Victor P -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel