Thank you for the reply. I apologize it took so long for me to get back to you.
I was thinking the same thing...I'm not real sure how to do go about that either.
A(current) is the only cell that doesn't change.
B(If B is changed, cells "C and I" need to calculate.
If they change C the cell B and need to calculate.
If cell I is changed then cell B and C need to calculate.
It doesn't look like I mentioned it above, but these cells are already populated, and there won't be any set way they enter data, so it just needs to be fool proof where it can't be broken. (They need a way to revert the numbers if they don't like the ending figures as well.- Essentially what they will be doing is playing with numbers. )
I think where I'm really struggling is if they change a cell that has a formula in it, and decide they don't like it, so they play with the other cells, then they have wiped out the formulas.
Thank you again. I do appreciate the help!
|