shreif mohamed
-
Posts
165 -
تاريخ الانضمام
-
تاريخ اخر زياره
-
Days Won
1
Community Answers
-
shreif mohamed's post in ارجو المساعدة ..كيف يتم التعامل مع عدة شروط was marked as the answer
In G3
=IF(OR(ISERROR(MATCH($C3,$I$5:$I$15,0)*MATCH($D3,$J$5:$J$15,0)*SUMPRODUCT(--($K$5:$O$5=$F3)*1)*1*--(DATEDIF(E3,TODAY(),"d")>365)),DATEDIF(E3,TODAY(),"d")<365),"علاوة","ترفيع")
Drag down
-
shreif mohamed's post in المساعدة في معادلة IF was marked as the answer
=IF(OR(14,16,18,20,25,32,35),(D2/1000)*60,"")