Dear Sanjay, Type your formula in cell D8 as follows, "=round(b8+c8,0)" enter this formula without quotation mark and read the formula with arrow keys thanking you.
On 9/12/14, Him Prasad Gautam <drishtibac...@gmail.com> wrote: > 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.. > -- together we can and we will make the differnce Zoher 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..
