Hi Guys,
Is it possible to combine this 2 formulas?
EG(SingaporePH)
=IF(R2="Singapore",IF(AND(B2-PH!$A$2<1, PH!$A$2-O2<1),1,0)+IF(AND(B2-PH!$A$3<1,PH!$A$3-O2<1),1,0)+IF(AND(B2-PH!$A$4<1,PH!$A$4-O2<1),1,0)+IF(AND(B2-PH!$A$5<1,PH!$A$5-O2<1),1,0)+IF(AND(B2-PH!$A$6<1,PH!$A$6-O2<1),1,0)+IF(AND(B2-PH!$A$7<1,PH!$A$7-O2<1),1,0)+IF(AND(B2-PH!$A$8<1,PH!$A$8-O2<1),2,0)
+IF(AND(B2-PH!$A$9<1,PH!$A$9-O2<1),1,0))
EG(GermanyPH)
=IF(R2="Germany",IF(AND(B2-PH!$D$2<1,PH!$D$2-O2<1),1,0)+IF(AND(B2-PH!$D$3<1,PH!$D$3-O2<1),2,0)+IF(AND(B2-PH!$D$4<1,PH!$D$4-O2<1),1,0)+IF(AND(B2-PH!$D$5<1,PH!$D$5-O2<1),1,0)+IF(AND(B2-PH!$D$6<1,PH!$D$6-O2<1),1,0)+IF(AND(B2-PH!$D$7<1,PH!$A$7-O2<1),1,0)+IF(AND(B2-PH!$D$8<1,PH!$D$8-O2<1),2,0)
+IF(AND(B2-PH!$D$9<1,PH!$D$9-O2<1),1,0)+IF(AND(B2-PH!$D$10<1,PH!$D$10-O2<1),2,0)+IF(AND(B2-PH!$D$11<1,PH!$D$11-O2<1),1,0)+IF(AND(B2-PH!$D$12<1,PH!$D$12-O2<1),1,0)+IF(AND(B2-PH!$D$13<1,PH!$D$13-O2<1),1,0)+IF(AND(B2-PH!$D$14<1,PH!$D$14-O2<1),1,0)+IF(AND(B2-PH!$D$15<1,PH!$D$15-O2<1),1,0)+IF(AND(B2-PH!$D$16<1,PH!$D$16-O2<1),1,0))
Thanks alot
Jordache
Bookmarks