Forum Discussion
Co Ltd LHM
Oct 03, 2017Copper Contributor
How to set a value for a cell?
Hello everyone. Please help. I'm not sure is it possible in Excel. If A1 is 1000 and I key 5 in B1 then the result 5000 is show on B1 or I key 8 in B1 the result will be 8000 in B1 OR I just set A...
JKPieterse
Oct 04, 2017Silver Contributor
Excel does not work that way easily. Simpler is:
Enter 1000 in A1
Enter 5 in B1
Enter =A1*B1 in C1.
C1 will always update if you make changes to A1 or B1.
Enter 1000 in A1
Enter 5 in B1
Enter =A1*B1 in C1.
C1 will always update if you make changes to A1 or B1.
- Co Ltd LHMOct 05, 2017Copper Contributor
Thanks.