Forum Discussion
Solved
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...
aayushman_mishra I have modified the formula, hopefully it will help.
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.
aayushman_mishra I have modified the formula, hopefully it will help.
tauqeeracma that was perfect , thank you so much.
aayushman_mishra You're welcome
tauqeeracma Hey, have successfully applied it and its working , but a condition im facing is that, now their is a value in column G i.e -750 and i have to take -600 to D and -150 to E , which makes up -750.