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

https://docs.google.com/spreadsheets/d/11ZZD60Yb8OIgFntw3ZUT1_sNwuZSoY7BFNuKr0BCoeY/edit?usp=sharing

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