circular reference

Hello, I am building a discounted cash flow model, which calculates my IRR at on a yearly stream of flows. I need a 25% IRR, so I have to manually change the purchase price until it hits. (Goal seek will not work on this model). Is it possible to create a circular reference so the purchase...

Hello, I'm trying to figure out how to perform a circular reference involving several cells. In cell d2 I am trying to get a final loan amount which is contingent upon several fees associated with doing the loan; these fees are in separate cells. Currently I have in cell d2: =c2+f2+g2+h2+j2+m2...

This is a little confusing but I'll try my best to explain my problem. In column E I have a list of strings, and I want to first determine if the string 00-EI is in this column. If this is true I want to then look at the next 2 columns (c and d) and determine if corresponding cells(ie. c3 &...

I have a worksheet with some references that Excel sees as circular. Actually, it is just some conditional if statements that calculate quantities from the front if front information is given, and from the back if back information is given. If I change the options to iterate the calculation, it...

I have a worksheet with some references that Excel sees as circular. Actually, it is just some conditional if statements that calculate quantities from the front if front information is given, and from the back if back information is given. If I change the options to iterate the calculation, it...

I have a column (say column A) of values that gives the current values of stocks and two other columns (columns B and C) that give the highest and lowest values the stocks reach respectively. I want the B and C columns to update accordingly if column A rises above or drops below the values...