Okay, this might sound a little bit complicated, so I hope ya'll can follow me. It's been a while since I've really used Excel this much, so feel free to talk to me like a newbie.

In my workbook, I have "Page1", in which, a list of dates will be added throughout time. Each date will have a series of numbers which will be added up, and provide a total.

"CellA" will provide me a running total, of those totals.

"CellB" will change automatically, based upon a comparisson of what is in "CellA"

Under each date row, there is "CellC" which will be this formula: "=CellB^2". However, this is a recursive formula. Meaning, "CellC" will constantly be changing, and thus constantly changing "CellA".

If I'm not being clear, I want "CellB" to look something like this:

=IF(CellA=1000,1,IF(CellA=2000,2,3))

My thing is, I want to be able to fill out each row, starting with the date, and then other variable cells, and have "CellC" filled out automatically. Once each cell in each date line is totaled, I'll have "CellA" calculate, and it'll lock "CellC" on what it was previously.

Confused yet? If you need further clarification, let me know.

I suppose the simplest way to say it is, I want "CellC" to lock, once all the cells in that row are filled out. Unfortunately, CellC runs the risk of being recursive, because one cell that it refers to, will be changing based upon the Total compiled from all rows. So how do I keep it from doing that?