Forum Discussion
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 A1 is 1000 (not shown on worksheet) and I key 5 in A1, the result 5000 will display on A1.
Hope you understand what I mean :p
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.
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.
- 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.Thanks.
