Thank you Richard!
I'm currently designing a prototype platform for the UK solar industry. Over the last 4-5 months i've become reasonably proficient with numbers and understand the majority of the functions, and have been able to get around most of the problems... streamlining as i learn more... however... I can't seem to find a solution to the last hurdle.. which is as follows.
I want to store/lock/freeze a particular value in a cell.
ideally i'd like to use a 'stepper' in increments of 1, such that i can say, when the value of the stepper cell equals '1, 2, 3' etc... a value that is entered/calculated in another cell is then stored in another cell, and that this 3rd cell holds that value even when the stepper is increased... how the buggery does one do that!!!
sorry richard, that didn't help clear things up.
I'm sure you get some really 'slow learners' here... i'm happy to be treated like a very slow learner!!
the formulae (for cells A1, A2, A3 etc) i'm trying to write goes something like this..
if cell B1(stepper) = 1, then cell A1 = the current value in cell C1
however if cell B1(stepper) = 2, then cell A1 still equals the value of C1 when B1(stepper) equaled 1....and then cell A2 will be exactly the same formula except when B1(stepper) = 2.... and when B1(stepper) =3 A2 will still equal the value of C1 when B1(stepper) was 2... and so on and so forth...
lets say c1 = 200
a1 = IF(B1=1,C1,0) was my starting point... but if i increase the value of b1, then A1 = 0.
which isn't what i want... if i increase b1.. i still want a1 to equal 200... i want to freeze the value