Excel - IF Function Problem - Expert Solution

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

I need a formula to say the following: if > then 110 then *1.5 if less < 110 then 110
Solved by G. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/06/2018 - 03:53
Hi
Excelchat Expert 07/06/2018 - 03:53
Welcome to Got It Pro.
Excelchat Expert 07/06/2018 - 03:54
You want to multiply the value with 1.5, when it is >110 and same value when it is less than 110?
Excelchat Expert 07/06/2018 - 03:54
What happens when it is =110
User 07/06/2018 - 03:55
if it's less then 110 then it should be 110 of greater then 110 this *1.5
Excelchat Expert 07/06/2018 - 03:55
Ok. I am working on the formula.
Excelchat Expert 07/06/2018 - 03:55
=if(A1>=110,A1*1.5,A1)
Excelchat Expert 07/06/2018 - 03:55
Please review the formula.
Excelchat Expert 07/06/2018 - 03:56
I have entered the number in A1 cell.
Excelchat Expert 07/06/2018 - 03:56
And formula written in B1 cell.
User 07/06/2018 - 03:56
I need it to return 110 if the total is 110
Excelchat Expert 07/06/2018 - 03:57
Ok.
User 07/06/2018 - 03:57
less then 110 sorry
User 07/06/2018 - 03:57
if it's more then 110 it should be *1.5
Excelchat Expert 07/06/2018 - 03:58
Please change the value in A1 cell.
Excelchat Expert 07/06/2018 - 03:58
It changes accordinly.
Excelchat Expert 07/06/2018 - 03:58
*accordingly.
Excelchat Expert 07/06/2018 - 03:59
=if(A1>=110,A1*1.5,110)
Excelchat Expert 07/06/2018 - 03:59
Please check it.
Excelchat Expert 07/06/2018 - 04:00
I have updated the formula, when it is less than 110.
User 07/06/2018 - 04:00
perfect
User 07/06/2018 - 04:00
thank you very much
Excelchat Expert 07/06/2018 - 04:00
Thank you.
Excelchat Expert 07/06/2018 - 04:00
Please end the session and leave valuable feedback.
Excelchat Expert 07/06/2018 - 04:00
Please do visit Got IT Pro.
Excelchat Expert 07/06/2018 - 04:00
Have wonderful day ahead.

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.