Aug 28 2020 03:58 AM
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.
Aug 28 2020 07:18 AM
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.
Aug 28 2020 07:45 AM
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
Aug 28 2020 07:56 AM - edited Aug 28 2020 07:58 AM
SolutionAs 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.
Aug 28 2020 07:56 AM - edited Aug 28 2020 07:58 AM
SolutionAs 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.