|Regardless of the value displayed in a cell, buried inside Excel is the actual value that Excel will use for calculations.|
Therefore, an IF statement evaluating >1.1 and <=1 is still going to have an issue with values between 1 and 1.1 if anything in that range is the result of the calculation in A1.
To prove this to yourself, enter 1.09 in A1 and format for 1 decimal place to display 1.1.
Now place this formula in B1:
=IF(A1>1.1, 1, IF(A1<1, 0))
You'll note that the answer is FALSE because you have not fullfilled any of the specified conditions.
Granted, if A1 will never (internally) be equal to a value between 1 and 1.1, then the formula will work. That is something only you can answer.
To get exactly what you asked for, this formula should work. However, it too will fail for values between 1 and 1.1.
If you really need an answer of 0 for values less than or equal to 1.1 as opposed to less than or equal to 1, then this should work:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.