As Your formula is circular , it will cause error Go to Excel Options>Formula>Iterations>Check the box on restart excel
Error will not get there On Fri, Feb 18, 2011 at 8:33 PM, vitorjose <victor_pa...@cox.net> wrote: > 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 > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- ---------------------------------------------------------------------------------- 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
