With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

I need help writing an if statement that is dependent on the conditions from two cell refs - see below.

Use similar logic displayed in formula below;

=MIN(IF(B1<=0),0,IF(AND(A1>=0,B1<5),1,IF(AND(B1>=5,A1<=10),2,IF(A1>=10,3,0)))) ,IF(A1>1250000,2,3))

IF YE Extrapolated <15,000 then return 0

If YE extrapolated >=15,000<50,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5<10 then return 2

OR

IF Pre YE >=10 then return 3

IF YE extrapolated is >=50,000 <1,250,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5<10 then return 2

OR

IF Pre YE >=10 then return** 4**

IF YE extrapolated is >=1,250,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5 then return 3

See expected result highlighted in yellow

Mike

Use similar logic displayed in formula below;

=MIN(IF(B1<=0),0,IF(AND(A1

IF YE Extrapolated <15,000 then return 0

If YE extrapolated >=15,000<50,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5<10 then return 2

OR

IF Pre YE >=10 then return 3

IF YE extrapolated is >=50,000 <1,250,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5<10 then return 2

OR

IF Pre YE >=10 then return

IF YE extrapolated is >=1,250,000 then apply the following IF statements;

IF Pre YE <=0 then return 0

OR

IF Pre YE >0<5 then return 1

OR

IF Pre YE >=5 then return 3

See expected result highlighted in yellow

Mike

```
=IF(OR(A2<15000, C2<=0), 0, IF(C2< 0.05, 1, IF(AND(A2<1250000, C2<0.1), 2, IF(AND(A2>=50000,A2<125000), 4, 3))))
```

Where A2 is the first row of data in the YE Extrapolated column, and C2 is the first row of data in the Pre YE column.

```
Function YE_YE(r As Range) As Integer
Select Case True
Case r(1) < 15000
YE_YE = 0
Case r(1) >= 15000 & r(1) < 50000
Select Case True
Case r(2) <= 0
YE_YE = 0
Case r(2) > 0 And r(2) < 5
YE_YE = 1
Case r(2) >= 5 And r(2) < 10
YE_YE = 2
Case r(2) >= 10
YE_YE = 3
End Select
Case r(1) >= 50000 & r(1) < 125000
Select Case True
Case r(2) <= 0
YE_YE = 0
Case r(2) > 0 And r(2) < 5
YE_YE = 1
Case r(2) >= 5 And r(2) < 10
YE_YE = 2
Case r(2) >= 10
YE_YE = 4
End Select
Case r(1) >= 1250000
Select Case True
Case r(2) <= 0
YE_YE = 0
Case r(2) > 0 And r(2) < 5
YE_YE = 1
Case r(2) >= 5
YE_YE = 3
End Select
End Select
End Function
```

I tried using the UDF but the results were not the same as the expected results.

Instead I got,

0

3

3

3

3

3

Could you show me the native excel formula used?

```
Function YE_YE(rA As Range, rC) As Integer
Select Case True
Case rA < 15000
YE_YE = 0
Case rA >= 15000 And rA < 50000
Select Case True
Case rC <= 0
YE_YE = 0
Case rC > 0 And rC < 5
YE_YE = 1
Case rC >= 5 And rC < 10
YE_YE = 2
Case rC >= 10
YE_YE = 3
End Select
Case rA >= 50000 And rA < 125000
Select Case True
Case rC <= 0
YE_YE = 0
Case rC > 0 And rC < 5
YE_YE = 1
Case rC >= 5 And rC < 10
YE_YE = 2
Case rC >= 10
YE_YE = 4
End Select
Case rA >= 1250000
Select Case True
Case rC <= 0
YE_YE = 0
Case rC > 0 And rC < 5
YE_YE = 1
Case rC >= 5
YE_YE = 3
End Select
End Select
End Function
```

pls try

```
=IF(A1<15000,0,MIN(IF(B1<=0,0,IF(AND(A1>0,B1<5),1,IF(AND(B1>=5,A1<=10),2,IF(A1>=10,3,0)))),IF(A1>1250000,2,3)))
```

Regards
See table below. Also see attached as Excel file.

if-statement-test.xlsx

All Courses

From novice to tech pro — start learning today.

Open in new window