-2

I want the formula to be in one cell, and the result in another cell. I do not want the answer to populate the cell that contains the formula.

Mark
  • 1

1 Answers1

1

I'm not sure exactly how to do it but I know a way around it that might help.

Say you have 4 columns , A,B,C and D.

And say you have numbers in A and B and you want C to show the formula and D to show the answer. For this example I'm going to say you want to add the values of A and B. So in the C column you enter '=A1+B1 , note the apostrophe before the "=" sign is important. And then in column D write =A1+B1. This will mean that D will show the answer and C will show the equation, but they won't be linked. So if you change the equation in D you'll have to change it in C and vice versa.

Niall
  • 11