Question description:
This user has given permission to use the problem statement for this
blog.
if c1 is between 10% and 20% then "A" if c1 is between 21% and 30% then "B" etc etc
Solved by C. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/06/2018 - 12:55
Hi! Welcome to Got it Pro.
User
10/06/2018 - 12:55
are you real?
Excelchat Expert
10/06/2018 - 12:56
I'm Joel. I will now try to explain your problem so that we'll know if we are on the same page.
Excelchat Expert
10/06/2018 - 12:56
Yes, I am real.
Excelchat Expert
10/06/2018 - 12:58
If c1 is between 10% and 20% then "A" if c1 is between 21% and 30% then "B". We will need an IF function. Are you familiar with it? I will input it in the excel file.
User
10/06/2018 - 12:58
i am familiar with it i cant seem to get it to work though.
Excelchat Expert
10/06/2018 - 01:02
Okay. It's not a simple IF function. I'll explain right after
User
10/06/2018 - 01:03
This has been killing me. I really hope you get it!
Excelchat Expert
10/06/2018 - 01:04
Can you see my input in Cell A2
User
10/06/2018 - 01:04
yes
Excelchat Expert
10/06/2018 - 01:04
I added the AND function.
User
10/06/2018 - 01:04
i have 5 "between percentages"
Excelchat Expert
10/06/2018 - 01:05
Yes, that is also applicable to that formula.
User
10/06/2018 - 01:06
You are the best
Excelchat Expert
10/06/2018 - 01:06
You will need a 5-6 IF's and AND's
Excelchat Expert
10/06/2018 - 01:06
That's called a nested IF-AND function.
User
10/06/2018 - 01:06
at the of my 5 ifs and ands do i have to have a 6th letter in brackets?
User
10/06/2018 - 01:07
in quotations rather
Excelchat Expert
10/06/2018 - 01:07
No.
Excelchat Expert
10/06/2018 - 01:07
That's optional
User
10/06/2018 - 01:07
right!
Excelchat Expert
10/06/2018 - 01:07
Try to check my formula again in A2. I deleted the "C"
User
10/06/2018 - 01:08
youre a genius. This thing is genius! do you get paid for this?
Excelchat Expert
10/06/2018 - 01:08
I hope I helped you.
Excelchat Expert
10/06/2018 - 01:08
Thank you for coming to Got It Pro.
Excelchat Expert
10/06/2018 - 01:09
I'm Joel once again. Please give a rate that satisfies you. Your feedback is precious to me.
User
10/06/2018 - 01:09
how do i get you again?
Excelchat Expert
10/06/2018 - 01:11
You can help to give me a high rate. In that way, a high chance will be given to me when you ask a problem.
Excelchat Expert
10/06/2018 - 01:12
Thank you, and I hope to chat with you soon.
Excelchat Expert
10/06/2018 - 01:12
Have a great day and happy working!
User
10/06/2018 - 01:12
we will be chatting soon. I have a lot to learn.
Excelchat Expert
10/06/2018 - 01:13
*Chat by mean working here and helping you as a student :) hehehe
User
10/06/2018 - 01:13
guess i cant get your email eh?
Excelchat Expert
10/06/2018 - 01:14
I'm sorry but we're not allowed to provide email to our students.
User
10/06/2018 - 01:14
okay ill be back
Excelchat Expert
10/06/2018 - 01:14
Sure! :)
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.