Forum Discussion
aayushman_mishra
Aug 14, 2019Copper Contributor
formula for data calculation
* By using formula , if the value in column G is between -1 to -200 then put the value in column E and if the value is exact -600 in column G theN put it in column D , and if the value is exact -5...
- Aug 14, 2019
aayushman_mishra I have modified the formula, hopefully it will help.
tauqeeracma
Aug 14, 2019Iron Contributor
aayushman_mishra Attached please find file with required formula.
- aayushman_mishraAug 14, 2019Copper Contributor
tauqeeracma but i wanted the column G should automatically go zero when we transfer value from this column to another by using the formula you gave.
- tauqeeracmaAug 14, 2019Iron Contributor
aayushman_mishra I have modified the formula, hopefully it will help.
- aayushman_mishraAug 14, 2019Copper Contributor
tauqeeracma that was perfect , thank you so much.
- SergeiBaklanAug 14, 2019Diamond Contributor
That's with macro if you'd like to move value from one cell to another.
- aayushman_mishraAug 14, 2019Copper Contributor
sir , i m just a beginner so please if you can help me with it. also i want the column G should get 0 automatically.