SOLVED
Home

formula for data calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-804693%22%20slang%3D%22en-US%22%3Eformula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804693%22%20slang%3D%22en-US%22%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E*%20By%20using%20formula%20%2C%20if%20the%20value%20in%20column%20G%20is%20between%20-1%20to%20-200%20then%20put%20the%20value%20in%20column%20E%20and%20if%20the%20value%20is%20exact%20-600%20in%20column%20G%20theN%20put%20it%20in%20column%20D%20%2C%20and%20if%20the%20value%20is%20exact%20-500%20then%20put%20it%20in%20the%20column%20F%20AND%20if%20the%20value%20is%201%20or%20more%20the%201%20then%20put%20it%20in%20H.%20%3CFONT%3EThis%20is%20a%20sample%20data%20%2C%20i%20have%20a%20data%20in%20large%20number%20so%20i%20have%20a%20need%20to%20do%20this%20automatically.%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Epls%20find%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-804693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804753%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20conditions%20to%20each%20of%20your%20columns%2C%20e.g.%20in%20D3%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(%24G3%3D-600%2CG3%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20down.%20Similar%20for%20other%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804765%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%20Attached%20please%20find%20file%20with%20required%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804769%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BSir%20i%20m%20unable%20to%20do%20%2C%20please%20if%20you%20can%20do%20a%20favour%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804786%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3Bbut%20i%20wanted%20the%20column%20G%20should%20automatically%20go%20zero%20when%20we%20transfer%20value%20from%20this%20column%20to%20another%20by%20using%20the%20formula%20you%20gave.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804804%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20macro%20if%20you'd%20like%20to%20move%20value%20from%20one%20cell%20to%20another.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804808%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804808%22%20slang%3D%22en-US%22%3E%3CP%3Esir%20%2C%20i%20m%20just%20a%20beginner%20so%20please%20if%20you%20can%20help%20me%20with%20it.%20also%20i%20want%20the%20column%20G%20should%20get%200%20automatically.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804822%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3BI%20have%20modified%20the%20formula%2C%20hopefully%20it%20will%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804831%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3Bthat%20was%20perfect%20%2C%20thank%20you%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804851%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%20Y%3CSPAN%3Eou're%20welcome%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804967%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20for%20data%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3BHey%2C%20have%20successfully%20applied%20it%20and%20its%20working%20%2C%20but%20a%20condition%20im%20facing%20is%20that%2C%20now%20their%20is%20a%20value%20in%20column%20G%20i.e%20-750%20and%20i%20have%20to%20take%20-600%20to%20D%20and%20-150%20to%20E%20%2C%20which%20makes%20up%20-750.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
aayushman_mishra
Occasional Contributor
* 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

@aayushman_mishra 

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_mishra  Attached please find file with required formula.

 

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

@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 

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

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

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

 

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