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.