Forum Discussion
Calculation using the IF function
I made the https://tuiasiro-my.sharepoint.com/:x:/g/personal/marius-stelian_imbrea_staff_tuiasi_ro/EcSuAMfDbrpMqPhgKrNi8ncBf6CwTwOLxdl2XFg3FObQ_g?e=Gk9ZSN to determine the indexes of some utility met...
With that formula in P4 you reference the cell F4. Formula in F4 in turn reference the range which includes F4. Thus circular reference. If in F4 take shorter range, e.g.
=LOOKUP(9.99E+307,G4:O4)-INDIRECT(ADDRESS(ROW(3:3)+1,MATCH(LOOKUP(9.99E+307,G3:O3),3:3,0)-1,4))it works.
You need to change the logic to exclude cross-references.
- Thank you
I understand the problem now
The proposed function does not solve the situation but it helped me to simulate and understand where the problem occurred.Yes, I didn't propose that as a formula to work, only to illustrate why an issue appeared.
