hi, There is next option. define d8 cell format as integer i.e. no decimal). Generally round (value,x) formula is used if x is a non zero number. formula
On 9/12/14, Zoher Kheriwala <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> 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/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ To unsubscribe send a message to [email protected] 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..
