EXCEL circular reference?
[Users questions | Browse:56 | Favorites]
Users questions: For example A2B25 when A2 = 5B2 = 0 (self-0) +5 = 5 to A2 revised 100B2 = 5 (reference itself) +100 = 105 A2 again revised 1000B2 = 105 (reference to what their +1000 = 1105 Zuodao ? seek out expert teach!!! ! Urgent
Experts answer: in the "Tools" menu, click "Options", then click "re-calculation" tab. Select the "iterative calculation" checkbox. Maximum number of iterations 1 and then cell B2 enter = A2 + B2 on it.
Experts answer: in the "Tools" menu, click "Options", then click "re-calculation" tab. Select the "iterative calculation" checkbox. Maximum number of iterations 1 and then cell B2 enter = A2 + B2 on it.
- Cell in Excel for graphics.
- domn down the word document, how to remove shading
- Download the Google input Thunder
- PPT pie method to do? Can quickly learn
- How to restore the default browser status ie
- WORD2003 program is broken
- the difference between word and wps?
- Ask CSS problems
- Hide Add Remove Programs
- Computer system and antivirus software
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.