**Question description:**

*This user has given permission to use the problem statement for this blog.*

I would like my result cell to display 1 of 5 values:
If my referenced cell value is less than 2 then the result cell should display 2. (values 0 thru 1.99 = 2)
but
if my referenced cell value is greater than 2 but less than 2.99 then the new cell should display 3 (values 2 thru 2.99 = 3)
but
if my referenced cell value is greater than 3 but less than 4.99 then the new cell should display 5 (values 3 thru 4.99 = 5)
but
if my referenced cell value is greater than 5 but less than 7.5 then the new cell should display 7.5 (values 5 thru 7.5 = 7.5)

Solved by S. Q. in 15 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/03/2018 - 02:49

hi

Excelchat Expert
16/03/2018 - 02:49

good mornning

User
16/03/2018 - 02:49

Good morning!

User
16/03/2018 - 02:51

Does my description make sense?

Excelchat Expert
16/03/2018 - 02:51

YES

User
16/03/2018 - 02:52

Not even sure where to start.

Excelchat Expert
16/03/2018 - 02:52

YES

Excelchat Expert
16/03/2018 - 02:52

JUST WORKING

User
16/03/2018 - 02:52

I can do the first IF(OR but after that I'm at a loss.

User
16/03/2018 - 02:52

roger that.

User
16/03/2018 - 02:53

Thanks for the help

Excelchat Expert
16/03/2018 - 02:53

YES ITS TRU

User
16/03/2018 - 02:57

5 should = 7.5

Excelchat Expert
16/03/2018 - 02:57

OK

Excelchat Expert
16/03/2018 - 03:01

NOW ITS PERFECT

User
16/03/2018 - 03:01

Yep. Well done!

Excelchat Expert
16/03/2018 - 03:01

THANK YOU

User
16/03/2018 - 03:01

Where can I see the formula?

Excelchat Expert
16/03/2018 - 03:02

=IF(A1<2,2,IF(A1<3,3,IF(A1<5,5,IF(A1<7.5,7.5,"7.5>"))))

Excelchat Expert
16/03/2018 - 03:02

THANK YOU FOR USING GOT IT PRO

User
16/03/2018 - 03:02

I love the service. I'll be using it again! Thank you!

Excelchat Expert
16/03/2018 - 03:02

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