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
It's pleasure to help you today.
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
Please visit Got It Pro.
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.