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
Can you paste your sample data so that i can help you better
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
Please see
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.