SOLVED

New Contributor

# Formulas

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

# Re: Formulas

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

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

# Re: Formulas

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

Best Response confirmed by Tommy_Taylor (New Contributor)
Solution

# Re: Formulas

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.

# Re: Formulas

Excellent response. I appreciate your help and patients