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 -500 then put it in the column F AND if the value is 1 or more the 1 then put it in H. This is a sample data , i have a data in large number so i have a need to do this automatically. |
pls find the attached file.
aayushman_mishra I have modified the formula, hopefully it will help.
10 Replies
aayushman_mishra Attached please find file with required formula.
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.
You may add conditions to each of your columns, e.g. in D3
=IF($G3=-600,G3,"")and drag it down. Similar for other columns.
SergeiBaklan Sir i m unable to do , please if you can do a favour .
