Talk:Damage Calculator/@comment-211.224.53.80-20130822044346/@comment-15871805-20130824044024

I have a quick question about excel. Wondering if you know the answer. Is there anyway to refer to the actual formula of a cell rather than just the result of the formula for that cell? Not sure at how great at explaining I am so I will make an example...

A1=5

A2=INDIRECT("C[-1]",FALSE) + 5

A3=INDIRECT("C[-1]",FALSE)

So, A1 is set to 5. A2 is set to the contents of A1 + 5, which is 10. Finally, A3 is set to the contents of A2, which is 10.

What I want is for A3 to be set to the literal formula of A2, so A3 would be INDIRECT("C[-1]",FALSE) + 5 = 10 + 5 = 15.

The reason for this would be so that you could just have 1 equation for each column and have all of the individual cells just copy that formula.