**Question description:**

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

I need both to fit together.
-A manual entry of 1 equals 11, if manual entry is less than 1 equals 5.5

Solved by G. B. in 23 mins

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

User
13/04/2018 - 04:35

Hi

Excelchat Expert
13/04/2018 - 04:35

hello there!

User
13/04/2018 - 04:35

I can't fit both formulas in one field

Excelchat Expert
13/04/2018 - 04:36

Let me help you with that! :)

User
13/04/2018 - 04:36

If(1,11>0.5,5.5)

User
13/04/2018 - 04:36

this is the just of what I am trying to do, but it does not work

Excelchat Expert
13/04/2018 - 04:36

Hmm. It seems wrong. Let me fix it for you! :)

User
13/04/2018 - 04:36

The only entries are 1 or 0.50

User
13/04/2018 - 04:37

Yup, it is wrong, lol

Excelchat Expert
13/04/2018 - 04:38

I've made a sample in the document preview. Can you see it?

User
13/04/2018 - 04:38

No

Excelchat Expert
13/04/2018 - 04:38

=if(A2>=1,11,5.5)

Excelchat Expert
13/04/2018 - 04:39

Do you have a working file?

User
13/04/2018 - 04:39

Le me try it

Excelchat Expert
13/04/2018 - 04:39

You can change A2 with the cell range of your manual entry.

User
13/04/2018 - 04:40

It

User
13/04/2018 - 04:40

And yes, I did change the A2 to correct cell

Excelchat Expert
13/04/2018 - 04:40

Can you upload in here your working file?

User
13/04/2018 - 04:40

Probably not, sorry

User
13/04/2018 - 04:41

What these are are 1 equals a shift of 11 hours and 0.5 equals a half shift of 5.5 hours

Excelchat Expert
13/04/2018 - 04:41

oh okay then. What's the cell range of your manual entry?

User
13/04/2018 - 04:41

On a row, it can vary from one cell to the next

User
13/04/2018 - 04:42

B34

Excelchat Expert
13/04/2018 - 04:42

and where do you wish to display the shift of the manual entry?

User
13/04/2018 - 04:43

in the same cell

User
13/04/2018 - 04:43

So, the entry 1 would change to 11 and the entry 0.5 would change to 5.5

User
13/04/2018 - 04:44

I can do it easy with just one formula, but I can