# Excel - IF Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.