SOLVED

Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1618331%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618331%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20my%20first%20time%20so%20I%20hope%20that%20I%20am%20explaining%20myself%20properly.%20I%20would%20like%20to%20know%20what%20the%20formula%20is%20to%20be%20able%20to%20pick%20out%20relevant%20data%20from%20one%20cell.%20Have%20a%20column%20with%20ages%20(D2)%3CSPAN%3E%26nbsp%3Bin%20another%20column%20(P2)%20I%20want%20to%20be%20able%20to%20process%20data%20with%20an%20age%20group%20above%2041%20and%20in%20another%2040%20and%20below%20with%20the%20existing%20formula.%20But%20what%20I%20am%20finding%20is%20that%20it%20is%20selecting%20all%20the%20data%20in%20that%20range.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618920%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774451%22%20target%3D%22_blank%22%3E%40Tommy_Taylor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20can%20help%20you%20with%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AGE%26lt%3B40%2C%26nbsp%3B%22Under%2040%20YO%22%2C%26nbsp%3BIF(AGE%26lt%3B80%2C%26nbsp%3B%2240%20YO%22%2C%26nbsp%3B%22Above%2041%20YO%22))%3C%2FP%3E%3CP%3ETranslating%20for%20your%20data%3C%2FP%3E%3CP%3E%3DIF(D2%26lt%3B40%2C%26nbsp%3B%22Under%2040%20YO%22%2C%26nbsp%3BIF(D2%26lt%3B80%2C%26nbsp%3B%2240%20YO%22%2C%26nbsp%3B%22Above%2041%20YO%22))%3C%2FP%3E%3CP%3EYou%20can%20literally%20keep%20a%20message%20or%20replace%20a%20message%20by%20any%20formula%20you%20want%20to%20apply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20answer%20is%20what%20you%20are%20looking%20for%2C%20don't%20be%20shy%20on%20hit%20the%20like%20button.%3C%2FP%3E%3CP%3EPlease%20don't%20forget%20to%20mark%20as%20Official%2FBest%20Answer%20to%20help%20the%20other%20members%20find%20it%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1619008%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1619008%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20contribution.%20How%20do%20I%20use%20the%20formula%20that%20has%20is%20in%20P2%20as%20well%20as%20what%20you%20have%20given%20me%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1619047%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1619047%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774451%22%20target%3D%22_blank%22%3E%40Tommy_Taylor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20mentioned%20before%2C%20you%20just%20need%20to%20replace%20what%20is%20written%20as%20text%20by%20your%20formula%3C%2FP%3E%3CP%3EFor%20instance%20I%20will%20replace%20the%20text%20%2240%20YO%22%20to%20your%20formula%20SUM(G2*1.5)%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(D2%26lt%3B40%2C%26nbsp%3B%22%3CU%3EUnder%2040%20YO%22%3C%2FU%3E%2C%26nbsp%3BIF(D2%26lt%3B80%2C%20%3CU%3E%3CFONT%20color%3D%22%23FF0000%22%3ESUM(G2*1.5)%3C%2FFONT%3E%3C%2FU%3E%2C%26nbsp%3B%3CU%3E%22Above%2041%20YO%3C%2FU%3E%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPs.%3A%20You%20can%20simplify%20the%20SUM(G2*1.5)%20by%20simply%20(G2*1.5)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(D2%26lt%3B40%2C%26nbsp%3B%22Under%2040%20YO%22%2C%26nbsp%3BIF(D2%26lt%3B80%2C%20%3CFONT%20color%3D%22%23FF0000%22%3EG2*1.5%3C%2FFONT%3E%2C%26nbsp%3B%22Above%2041%20YO%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20answer%20is%20what%20you%20are%20looking%20for%2C%20don't%20be%20shy%20on%20hit%20the%20like%20button.%3C%2FP%3E%3CP%3EPlease%20don't%20forget%20to%20mark%20as%20Official%2FBest%20Answer%20to%20help%20the%20other%20members%20find%20it%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1619922%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1619922%22%20slang%3D%22en-US%22%3EExcellent%20response.%20I%20appreciate%20your%20help%20and%20patients%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

This is my first time so I hope that I am explaining myself properly. I would like to know what the formula is to be able to pick out relevant data from one cell. Have a column with ages (D2) in another column (P2) I want to be able to process data with an age group above 41 and in another 40 and below with the existing formula. But what I am finding is that it is selecting all the data in that range. 

4 Replies
Highlighted

@Tommy_Taylor 

I hope I can help you with this

 

=IF(AGE<40, "Under 40 YO", IF(AGE<80, "40 YO", "Above 41 YO"))

Translating for your data

=IF(D2<40, "Under 40 YO", IF(D2<80, "40 YO", "Above 41 YO"))

You can literally keep a message or replace a message by any formula you want to apply.

 

If the answer is what you are looking for, don't be shy on hit the like button.

Please don't forget to mark as Official/Best Answer to help the other members find it too.

 

 

Highlighted

Thank you for your contribution. How do I use the formula that has is in P2 as well as what you have given me? @Juliano-Petrukio 

Highlighted
Best Response confirmed by Tommy_Taylor (New Contributor)
Solution

@Tommy_Taylor 

As mentioned before, you just need to replace what is written as text by your formula

For instance I will replace the text "40 YO" to your formula SUM(G2*1.5)

=IF(D2<40, "Under 40 YO", IF(D2<80, SUM(G2*1.5)"Above 41 YO"))

 

Ps.: You can simplify the SUM(G2*1.5) by simply (G2*1.5)

=IF(D2<40, "Under 40 YO", IF(D2<80, G2*1.5, "Above 41 YO"))

 

If the answer is what you are looking for, don't be shy on hit the like button.

Please don't forget to mark as Official/Best Answer to help the other members find it too.

Highlighted
Excellent response. I appreciate your help and patients