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