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
Open in new window

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.