Multiple criteria solution

[End3r]

Hello,

I have a problem getting results with set of criterias that override next one within one formula.
So, i have the following several data:

- number of days
- destination 1
- destination 2
- unexpected delay reason

first criteria is easy, if shipment arrives in 1 day or below then value YES.
Second one can override with following, if shipment arrived on second day and destination is 1 then value is yes if its larger then 2 value can still be yes if unexpected delay reason is met.

Thanks for all your help !

 

[oldbrewer]

destination	days	accept_delay_reason	is it ok
1	1		yes	#####
1	2	yes	yes
2	2	no	no
1	2	no	yes
2	3	yes	yes
2	2	no	no
1	2	no	yes
1	2	yes	yes
2	2	yes	yes
		#####
		=IF(C2="yes","yes",IF(AND(A2=1,B2<3),"yes",IF(AND(A2=2,B2>1),"no","yes")))
		not sure if this is what you want

<colgroup><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>