Yes. That's true. I'll nest both the formula as Zoher Kheriwala
suggested.
Thanks to both of you.
----- Original Message -----
From: "Him Prasad Gautam" <[email protected]>
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled." <[email protected]>
Sent: Friday, September 12, 2014 11:11 AM
Subject: Re: [AI] excel question
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..
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..
