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.