Hi
I'm trying to create a basic Excel document intended for use as an navigation log.
I'm having a problem with circular references.
Here is what I'm trying to do:
True track: A1=B1-C1
Mag. track: B1=A1+C1
Mag. variation: C1
The idea being when you open the document you enter the true track or magnetic track depending on the information derived from the chart. The document then calculates either mag. or true track for you depending on where you entered the information. I then have 25 or so rows of this.
The problem I'm having is that once excel "sees" any circular references in the sheet it brakes down and some other functions stop working. Since you usually don't use all the rows available the document will always contain these circular references.
I know I can disable the circular reference warning and that fixes the issue but as I'm intending to share the log I'd rather find another solution.
I tried IFERROR and I couldn't get it to work.
Any suggestions?
Is there no function similar to IFERROR so that if a function contains a circular reference it will return some fixed value?
Bookmarks