# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I WANT TO WRITE A FUNCTION FOR THESE STATEMENTS If 1000>C2>=600 display 2A if 600>C2>=300 display 2B If 300>C2>=100 display 2C If 100 < C2 display 2d
Solved by V. U. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/10/2017 - 09:05
Hello! Thanks for choosing Got It Pro-Excel.
User 24/10/2017 - 09:05
Ok.
User 24/10/2017 - 09:05
I want to write a function for the statements I've put above can you help?
Excelchat Expert 24/10/2017 - 09:05
We
Excelchat Expert 24/10/2017 - 09:05
sure :)
Excelchat Expert 24/10/2017 - 09:06
Do you have any data for us to make the test?
Excelchat Expert 24/10/2017 - 09:06
I'm so glad to support you on this function.
User 24/10/2017 - 09:06
No just need the formula ....
Excelchat Expert 24/10/2017 - 09:06
Alright, I'll give you the sample for this
User 24/10/2017 - 09:07
The last one should be if C2<100....
Excelchat Expert 24/10/2017 - 09:07
as shown at our Document preview, please give me few minutes to set it up
User 24/10/2017 - 09:07
ok
Excelchat Expert 24/10/2017 - 09:07
thanks
Excelchat Expert 24/10/2017 - 09:11
Well, I will create the formula in Google Spreadsheet then share the link with you, will this be fine?
User 24/10/2017 - 09:11
yes
Excelchat Expert 24/10/2017 - 09:11
Thank you
Excelchat Expert 24/10/2017 - 09:19
I will be sharing my formula at this link
Excelchat Expert 24/10/2017 - 09:19
User 24/10/2017 - 09:19
ok
Excelchat Expert 24/10/2017 - 09:20
still checking on it
Excelchat Expert 24/10/2017 - 09:21
just a little bit of checking val;idation
Excelchat Expert 24/10/2017 - 09:22
please bear with me on your time
Excelchat Expert 24/10/2017 - 09:22
Thanks
Excelchat Expert 24/10/2017 - 09:27
well, this is my formula
Excelchat Expert 24/10/2017 - 09:28
=if(100<value(C2),"2d",if(or(300>C2,C2>=100),"2C",if(or(600>C2,C2>=300),"2B",if(AND(1000>C2,C2>=600),"2A"))))
Excelchat Expert 24/10/2017 - 09:28
Its working on excel desktop, just a bit wondering why there's a problem on spreadsheet
Excelchat Expert 24/10/2017 - 09:28
Can you see it?
User 24/10/2017 - 09:29
I can see the formula.
User 24/10/2017 - 09:29
It should be C2 less than 100.....
User 24/10/2017 - 09:29
then display 2d
User 24/10/2017 - 09:29
Why do you say there's a problem on spreadsheet?
Excelchat Expert 24/10/2017 - 09:30
yes, it was right at first, but when added more formula, then gives wrong resulkt
Excelchat Expert 24/10/2017 - 09:30
I've tried on my excel in desktop
Excelchat Expert 24/10/2017 - 09:40
Hello
Excelchat Expert 24/10/2017 - 09:41
Since, you have the link already, please check on this everytime
Excelchat Expert 24/10/2017 - 09:41
I'm about to get the logic for 2B and 2A
Excelchat Expert 24/10/2017 - 09:41
just a bit

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