# Excel - IF Function Problem - Expert Solution

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

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.