**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula to say that if cell A1 for example has a value less than or equal to 21 then show "Low Anxiety", if it has value of 22-35 then show "Moderate Anxiety" and if it has value of 36 and above, then show "Potential Cause For Concern"

Solved by D. H. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/02/2018 - 03:53

hi welcome to got it pro

User
16/02/2018 - 03:53

Hi there

Excelchat Expert
16/02/2018 - 03:54

i will be able to assist you with your query

User
16/02/2018 - 03:54

=IF([@SCORE]<=21, "Low Anxiety", IF(AND([@SCORE]>=22, [@SCORE]<=35), "Moderate Anxiety"), IF(AND([@SCORE]>=36), "Potential Cause For Concern"))

Excelchat Expert
16/02/2018 - 03:54

let me have a look Pls

User
16/02/2018 - 03:54

I already wrote this, but it says too many arguments

Excelchat Expert
16/02/2018 - 03:54

sure

User
16/02/2018 - 03:54

thank you

Excelchat Expert
16/02/2018 - 03:54

let me have a look pls

Excelchat Expert
16/02/2018 - 03:58

do you have a excel sheet pls

Excelchat Expert
16/02/2018 - 03:58

if you can share i can amend in that it self

Excelchat Expert
16/02/2018 - 03:58

or else i can share formulae with you

User
16/02/2018 - 03:59

If you could just share the formula with me, I would appreciate it

Excelchat Expert
16/02/2018 - 03:59

sure working on it

User
16/02/2018 - 03:59

Thank you

Excelchat Expert
16/02/2018 - 04:05

al most done

User
16/02/2018 - 04:05

sure, take your time

Excelchat Expert
16/02/2018 - 04:05

thanks

Excelchat Expert
16/02/2018 - 04:20

testing now

Excelchat Expert
16/02/2018 - 04:22

hi dear

Excelchat Expert
16/02/2018 - 04:22

r u there

User
16/02/2018 - 04:23

yes I am

Excelchat Expert
16/02/2018 - 04:23

Pls use this formulae

Excelchat Expert
16/02/2018 - 04:23

=IF(A1>=36,"Potential Cause For Concern",IF(A1>=22,"Moderate Anxiety",IF(A1>=35,"Moderate Anxiety",IF(A1<=21,"Low Anxiety",))))

Excelchat Expert
16/02/2018 - 04:23

just copy and paste

Excelchat Expert
16/02/2018 - 04:24

r u able to see the working pls

User
16/02/2018 - 04:25

perfect, it works!

Excelchat Expert
16/02/2018 - 04:25

great,..

Excelchat Expert
16/02/2018 - 04:25

happy to know that

Excelchat Expert
16/02/2018 - 04:25

Thanks for chatting Got it Pro

Excelchat Expert
16/02/2018 - 04:25

any thing else

Excelchat Expert
16/02/2018 - 04:25

pls

User
16/02/2018 - 04:26

thats it!

Excelchat Expert
16/02/2018 - 04:26

you have a great day,

Excelchat Expert
16/02/2018 - 04:26

Tc

User
16/02/2018 - 04:26

you helped me alot

User
16/02/2018 - 04:26

thank you so much

Excelchat Expert
16/02/2018 - 04:26

good to know that,..

Excelchat Expert
16/02/2018 - 04:26

happy for u

Excelchat Expert
16/02/2018 - 04:26

Tc

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*