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.
SergeiBaklan
Aug 14, 2019Diamond Contributor
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.
- aayushman_mishraAug 14, 2019Copper Contributor
SergeiBaklan Sir i m unable to do , please if you can do a favour .