If I have one cell dependent on another, say B1 has '=A1 + 10' in it (it could be any dependent formula); I need the special formula to go in A1 that basically says, "put a number in this cell that will make A1 change to 100 (or whatever other number I choose)".
I'm almost certain I've seen someone use such a formula but can't remember what it is, and don't really know where to start searching. Anyone know what I'm getting at? Cheers.
I'm almost certain I've seen someone use such a formula but can't remember what it is, and don't really know where to start searching. Anyone know what I'm getting at? Cheers.