halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
I have cell K12 in which a summed value is displayed. There are thresholds (reflected by CF colouring). That's by the by I realise. These relates to subjective descriptions of low, medium, high, extra high.
In the cell below (in K13) what do I need to put in to get, depending on the score, the following text results:
If k12 = to 20 "Low"
If k12 between 21 and 50 "Med"
If k12 between 51 and 90 "High
If k12 between 91 and 160 "Med"
How do I do that (I'm ok with a single one of these but not the stringing together correctly!).
Thank you!
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
In the cell below (in K13) what do I need to put in to get, depending on the score, the following text results:
If k12 = to 20 "Low"
If k12 between 21 and 50 "Med"
If k12 between 51 and 90 "High
If k12 between 91 and 160 "Med"
How do I do that (I'm ok with a single one of these but not the stringing together correctly!).
Thank you!
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]