Forum Discussion
Forumula Help
Hi guys Is there anyway to make a number/text from a table not change? For example I have the following table below and a formula in cell C4 showing =A1(10). Is there anyway to make C4 show 1...
When you enter =A1 in C4, that formula means: return in C4 whatever value is stored in A1. So, if the value in A1 is 10, the formula in C4 also returns 10. If the value in A1 subsequently changes to 11, the result in C4 also changes to 11.
If you want the value in C4 to remain 10 although the value in A1 changes to 11 or another value, do not enter a formula in C4, simply enter 10.