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