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..
