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...
Windows Phone 8.1
Oct 04, 2017Copper Contributor
Hi. Both the scenarios are difficult to carry out as you are editing cell which you wish to keep dynamic.
So like suggested by other user, you will have to take it to another cell like C1..
Even a Macro will not be able to determine changes to cell B1( per schenarios 1) and update B1 again with response. You need new value stored.
I tried something like this (=IF(B2<>B1,B2,A1*B1)) But Excel returns 0 each time.
So guess you will have to amend the requirement.
- Co Ltd LHMOct 05, 2017Copper Contributor
Thanks. I will use the normal method (C1=A1*B1) to calculate the result. As I need to do this daily and not only 1000 but also have others value, so I want to find the faster way.
Anyway, thanks for your help again. Thank you.