# Excel - IF Function Problem - Expert Solution

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

If cell D10 is less than 5 I need D11 to be one price. If cell D10 is more 6-13 I need D11 to be a different price. If cell d10 is OVER 13 I need D11 to be another price. So far I have =IF(D11<=5, "16.04", "18.48") but I can't seem to figure out how to add the third in there. over 13. I really need the second one to be 6-12 not >5.
Solved by D. Q. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/05/2018 - 09:37
HI,
User 30/05/2018 - 09:37
hi
Excelchat Expert 30/05/2018 - 09:37
Excelchat Expert 30/05/2018 - 09:37
Please share the price range in preview.
Excelchat Expert 30/05/2018 - 09:37
I can update the formula as required.
Excelchat Expert 30/05/2018 - 09:39
Ok. I am working on it
User 30/05/2018 - 09:39
ok see the 26.04
User 30/05/2018 - 09:39
16.04
User 30/05/2018 - 09:39
I need it to say
User 30/05/2018 - 09:39
if B5 is 0-5 then C5 = 16.04
Excelchat Expert 30/05/2018 - 09:40
Ok.
User 30/05/2018 - 09:40
if B5 is 6-12 then C5 = 18.48
User 30/05/2018 - 09:40
if B5 is 13+ then C5 = 20.46
Excelchat Expert 30/05/2018 - 09:40
6-13? or 6-12?
User 30/05/2018 - 09:40
6-12
User 30/05/2018 - 09:40
so 0-5 6-12 13+
Excelchat Expert 30/05/2018 - 09:41
Ok. Thank you for the information.
User 30/05/2018 - 09:42
0-5yrs - \$16.04/day 6-12yrs - \$18.48/day 13+years - \$20.46/day
Excelchat Expert 30/05/2018 - 09:42
I am working on it. Please give me a minute.
User 30/05/2018 - 09:42
This is what I am tryng to do. Put that into C5 so all i have to do is put the age and it shows the amt lol thank you
Excelchat Expert 30/05/2018 - 09:43
=IF(D10>=13,20.46,IF(D10>=6,18.48,16.04))
Excelchat Expert 30/05/2018 - 09:43
Here is the formula. In these cases, you have to start from the maximum value.
User 30/05/2018 - 09:44
YAY!!!
User 30/05/2018 - 09:44
omga thank u
User 30/05/2018 - 09:44
I have been racking my brain forever
Excelchat Expert 30/05/2018 - 09:44
No worries.
Excelchat Expert 30/05/2018 - 09:44
You have come to the right platform.
Excelchat Expert 30/05/2018 - 09:44
Excelchat Expert 30/05/2018 - 09:44
Have great day ahead. Please leave great rating after closing the session. Thank you.
User 30/05/2018 - 09:45
will do thank you

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.