Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to create an IF statement with a range.
Example:
IF B1 is >100 but <200 then 300$ shows up
IF B1 is >201 but <300 then 425$ shows up
IF B1 is >301 then 600$ shows up
Solved by T. U. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/03/2018 - 06:13
Hi, It's pleasure to help you today.
User
29/03/2018 - 06:14
thank you
Excelchat Expert
29/03/2018 - 06:14
I have understood the instructions.
Excelchat Expert
29/03/2018 - 06:14
I am working on it.
Excelchat Expert
29/03/2018 - 06:15
=if(B1>301,600,if(B1>201,425,if(B1>100,300,0)))
Excelchat Expert
29/03/2018 - 06:15
I have used nested if formula for this case.
Excelchat Expert
29/03/2018 - 06:15
When it is less than 100, then it is 0.
User
29/03/2018 - 06:16
so i dont need the 'less than'
User
29/03/2018 - 06:16
?
Excelchat Expert
29/03/2018 - 06:16
It is part of else condition.
Excelchat Expert
29/03/2018 - 06:16
I am coming from higher end, so, less than is not requied.
User
29/03/2018 - 06:17
ohhh
User
29/03/2018 - 06:18
i see
User
29/03/2018 - 06:18
i did try it this way but went from the low end and as soon as it saw the true value it would look any further
Excelchat Expert
29/03/2018 - 06:18
=if(B1>301,600... In this case, false condition is <=300.
User
29/03/2018 - 06:18
wouldnt**
Excelchat Expert
29/03/2018 - 06:18
Usually, we have to do this from higher end.
Excelchat Expert
29/03/2018 - 06:19
When we start from lower end, we have to use and conditions and is complex one.
User
29/03/2018 - 06:20
can i still format to show the 600 in currency?
Excelchat Expert
29/03/2018 - 06:20
Yes. That is cell format only.
User
29/03/2018 - 06:20
roger
Excelchat Expert
29/03/2018 - 06:21
Please check C1 cell.
Excelchat Expert
29/03/2018 - 06:21
I have used the formula and applied cell format to currency.
Excelchat Expert
29/03/2018 - 06:21
It works perfectly.
Excelchat Expert
29/03/2018 - 06:21
Thank you. Please visit Got It Pro for new queries. Have a great day ahead.
User
29/03/2018 - 06:21
thank you!
User
29/03/2018 - 06:21
it worked perfectly
User
29/03/2018 - 06:22
have a great day
Excelchat Expert
29/03/2018 - 06:22
Great to hear it.
Excelchat Expert
29/03/2018 - 06:22
Thank you.
Excelchat Expert
29/03/2018 - 06:22
Please leave great feedback.
User
29/03/2018 - 06:22
will do
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.