Excel: If Less Than and Greater Than or Equal

Good evening,

=IF(A11=1,2,IF(AND(B11>12,B11<=14),5))

it returns if A11=1 ---> in A1: 2

if A11 is different from 1 and B11= 13 ---> in A1:5

=IF(AND(A1<=14,A1>11),5,IF(A1=0,0,IF(A1=1,0.25,IF(A1=2,0.5,IF(A1=3,0.75,IF(A1=9,1,IF(A1=10,1,IF(A1=11,1,"NULL"))))))))

This formula states that "NULL" will be written in cell B11 if none of the given conditions are met.
Is that what you meant?
See you
--

"To find a solution to your problems, you have to make the effort."

IIF(Condition; TRUE statement; FALSE statement)

and what do you want to achieve because it doesn't make sense to say "12<b11 it="" just="" means="" that="" b11="" must="" be="" between="" and="" but="" not="" take="" a="" specific="" value="" />
anyway it has nothing to do with it? IF(A11=1;2;IF(B11=12;5))
because it means that if A11 = 1 then the result is 2, otherwise if B11 equals 12 then the result is 5 otherwise there is no result.

```html

I reformulate my question. I have a cell A1 where I put =IF(A11=1,2,IF(B11>=12 AND B11<=14,5))

This means that if A11=1 then I will have 2 in A1.

If B11 is between 12 and 14, then A1 takes the value 5.

But this does not suit me, because I want that instead of B11=12,5,

I have if B11 is between 12 and 14 then A1 takes the value 5.

It's not the same thing at all but that's what I would like to have.

Thank you.

```

'Hi,
You're welcome and have a good evening.
--

"To find a solution to one's problems, one must put in the effort."

Thank you all and see you soon.

Thank you.

```vba
Sub ColorierCellules()
Dim i As Integer
Dim A(1 To 4) As Double
Dim B(1 To 4) As Double
Dim C(1 To 4) As Double
Dim Z As Boolean

' Initialise les valeurs
A(1) = 100
A(2) = 100
A(3) = 100
A(4) = 100

B(1) = 0
B(2) = 50
B(3) = 100
B(4) = 100

Z = True ' Détermine si Z est coché ou non

' Calcule la colonne C
For i = 1 To 4
C(i) = A(i) - B(i)
If C(i) = 0 And Z Then
Cells(i, 3).Interior.Color = RGB(255, 255, 255) ' Blanc
ElseIf C(i) = 0 Then
Cells(i, 3).Interior.Color = RGB(0, 255, 0) ' Vert
ElseIf C(i) < A(i) Then
Cells(i, 3).Interior.Color = RGB(255, 165, 0) ' Orange
ElseIf C(i) = A(i) Then
Cells(i, 3).Interior.Color = RGB(255, 0, 0) ' Rouge
End If
Next i
End Sub
```