circular reference

Hello! Thank you for reading this. I'm really stumped at how to achieve what I call an "update in place" with excel 2003 I have a worksheet that I print out that is used in the shop. They keep track of the amount of product used and turn this sheet in for update. The sheet looks like this...

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...