Expert Solution - Excel IF Problems

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

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.