Excel cell reference issue?
Please help me with this problem....i have an excel sheet which i have to implement in browser using javascript ..in excel sheet ther is one cell where iterations is beingf performed..the formula is
T330 = IF(T328="",T330*T335,T328) and the value in T330 comes out to be 11.57238 ,T328 is Null and T335 is 1..my question is how we get the value of T330 for the very first time ..means for iteration where we initialize T330..so that we can iterate..
More Questions From This User See All
Answers & Comments
Verified answer
Actually, circular references can be a very useful tool in Excel.
http://chandoo.org/wp/2010/09/16/excel-circular-re...
You have a circular reference in T330 (i.e. the formula in T330 also refers to the same cell (T330). This is illegal in Excel and the value of the cell becomes zero as far as I know. You will need to resolve the circular reference.
To garbo7441: I did not know that. Thanks for the info and the link.