# Excel - IF Function Problem - Expert Solution

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.

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.

## Click here to get your free Excelchat help session

Trusted by people who work at