IFS query (I think)

[slgriff]

I really hope that someone could help me with this one as I have tried to study videos and still have no idea how to do what I'm looking to achieve, an I apologise if I'm not explaining properly.

I have master table of data that I'm looking to develop a report from:

[TABLE="width: 458"]
<colgroup><col width="307" style="width: 230pt; mso-width-source: userset; mso-width-alt: 11227;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" span="3"> <tbody>[TR]
[TD="width: 307, bgcolor: transparent"]Developing Self Awareness[/TD]
[TD="width: 101, bgcolor: transparent"]Score[/TD]
[TD="width: 101, bgcolor: transparent"]Manager Score[/TD]
[TD="width: 101, bgcolor: transparent"]Combined[/TD]
[/TR]
[TR]
[TD="width: 307, bgcolor: transparent"]Average[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1.666666667[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1.333333333[/TD]
[/TR]
[TR]
[TD="width: 307, bgcolor: transparent"]I continuously seek the feedback of those around me in order to be the best leader I can be[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="width: 307, bgcolor: transparent"]I promote resilience and wellbeing within my team and lead by example[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]3[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="width: 307, bgcolor: transparent"]I demonstrate positive and effective communication skills (listening, feedback, recording, sharing) to enable to my team to deliver the best possible outcomes for the people we support and their loved ones.[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 101, bgcolor: transparent, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

I would like to know:

If the combined score I 1 or 0 for the text field to show under a development heading and if the combined score is 2 or 3 then the text on the left to show under a strengths heading as below

Strengths

I promote resilience and wellbeing within my team and lead by example

Development

I continuously seek the feedback of those around me in order to be the best leader I can be

I am really hoping that someone can help with this and thank you in advance

 

[Fluff]

Cross posted http://www.msofficeforums.com/excel/41087-ifs-query-i-think.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.