Perhaps you have written =round(d8,0) in d8 cell itself. Circular reference means the cell in which the formula is written falls with the refered cell within the formula.
On 9/11/14, sanjay <sanjaylpra...@yahoo.co.in> wrote: > Friends, > > In d8 I have > 18136.5 > > which is sum of b8 and c8. I tried to round it to the nearest digit, > that is, > 18137. After typing =round(d8,0) I am getting the folowing error. > > > > Microsoft Office Excel > Circular Reference Warning > One or more formulas contain a circular reference and may not calculate > correctly. Circular references are any references within a formula that > depend upon > the > results of that same formula. For example, a cell that refers to its own > value or a cell that refers to another cell which depends on the original > cell's > value both > contain circular references. > For more information about understanding, finding, and removing circular > references, click OK. If you want to create a circular reference, click > Cancel > to > continue. > Please let me know how to write more than one formulae in a cel, and > also, where I am wrong? > Thanks. > > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Him Prasad Gautam Kathmandu, Nepal Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
