 • 436K Members
• 10.2K Online
• 521K Conversations
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.

10 Replies

# Re: formula for data calculation

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.

# Re: formula for data calculation

@aayushman_mishra  Attached please find file with required formula.

# Re: formula for data calculation

@Sergei Baklan Sir i m unable to do , please if you can do a favour .

# Re: formula for data calculation

@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.

# Re: formula for data calculation

That's with macro if you'd like to move value from one cell to another.

# Re: formula for data calculation

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.

Solution

# Re: formula for data calculation

@aayushman_mishra I have modified the formula, hopefully it will help.

# Re: formula for data calculation

@tauqeeracma that was perfect , thank you so much.

# Re: formula for data calculation

@aayushman_mishra  You're welcome

# Re: formula for data calculation

@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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies