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.