Excel - IF Function Problem - Expert Solution

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

I need column V to show a number determined by a number in column U being within a certain range from a range table i.e. if column U reads between 52 and 62 then column V should show 5 if column V changes to a number between 63 and 74 column U should change to show 6
Solved by K. L. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/04/2018 - 04:46
Hi
Excelchat Expert 29/04/2018 - 04:46
Welcome to Got it Pro
User 29/04/2018 - 04:46
Hi
Excelchat Expert 29/04/2018 - 04:46
Excelchat Expert 29/04/2018 - 04:48
Please explain the conditions so that i can build the formula
Excelchat Expert 29/04/2018 - 04:48
There is no value in column U
Excelchat Expert 29/04/2018 - 04:48
Please tell where is the formula required and based on which cell
User 29/04/2018 - 04:48
if column P is between 0-15 column Q should read U
Excelchat Expert 29/04/2018 - 04:49
but U does not ahve any value
User 29/04/2018 - 04:49
I removed confidential information which has shifted the table to the left
User 29/04/2018 - 04:49
if P is between 15 and 24 Q should show F
User 29/04/2018 - 04:50
if P is between 25 and 32 Q should show E
Excelchat Expert 29/04/2018 - 04:51
=if(AND(P4>0,P4<=15),U4,if(AND(P4>15,P4<=24),F4,if(AND(P4>24,P4<=32),E4,"")))
Excelchat Expert 29/04/2018 - 04:51
this is the formula
Excelchat Expert 29/04/2018 - 04:51
have put in Q
Excelchat Expert 29/04/2018 - 04:51
User 29/04/2018 - 04:52
I mean the letter 'U'
Excelchat Expert 29/04/2018 - 04:52
if value maches nothing then i have left it blank value
Excelchat Expert 29/04/2018 - 04:53
Ok
Excelchat Expert 29/04/2018 - 04:53
Done
Excelchat Expert 29/04/2018 - 04:53
=if(AND(P4>0,P4<=15),"U",if(AND(P4>15,P4<=24),"F",if(AND(P4>24,P4<=32),"E","")))
Excelchat Expert 29/04/2018 - 04:53
This is the formula
Excelchat Expert 29/04/2018 - 04:53
try changing value in column P
Excelchat Expert 29/04/2018 - 04:53
And see
User 29/04/2018 - 04:54
Thank you
Excelchat Expert 29/04/2018 - 04:54
Let me know if this helps you buddy
User 29/04/2018 - 04:54
that works
Excelchat Expert 29/04/2018 - 04:54
Welcome
Excelchat Expert 29/04/2018 - 04:54
Please do give good rating and reviews
Excelchat Expert 29/04/2018 - 04:54
It really helps
User 29/04/2018 - 04:54
of course excellent service
Excelchat Expert 29/04/2018 - 04:54
Thanks

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.