IF formulas

[reza]

Hi Expert....

guys...hope you can help me with formulas...(ms Excel 2007)
Line Col A Col B Col C Col D
Col E
1 AA 10 5 4
2
2 BB 6 2 2
-
3 CC 8 8 8
8

Col A : name
Col B ; Baseline

from above i want to have result like:
AA, 5 from 10 respondent, 4 complete & 2 pass QC
BB, 2 from 6 respondent, 2 complete & not yet pass QC
CC, 8 respondent closed, already completed & pass QC (since all values
already same with col B)

hope you can helps me

thanks in advance

reza

 

[Jacob Skaria]

In cell F1 try the below formula and copy down as required

=A1 & ", " & IF(COUNTIF(B1:E1,B1)=4,B1+0&" respondent closed, already
completed and pass QC",C1+0&" from "&B1+0&" respondent, "&D1+0&" complete &
"& IF(E1<=0,"not yet pass QC",E1&" pass QC"))

If this post helps click Yes

 

[reza]

wow...great...

many many thanks....

reza

In cell F1 try the below formula and copy down as required

=A1 & ", " & IF(COUNTIF(B1:E1,B1)=4,B1+0&" respondent closed, already
completed and pass QC",C1+0&" from "&B1+0&" respondent, "&D1+0&" complete &
"& IF(E1<=0,"not yet pass QC",E1&" pass QC"))

If this post helps click Yes

 

[reza]

Jacob...

can you add more result...
Line Col A Col B Col C Col D Col E
4 DD 5 3 0 0
with result
DD, 3 from 5 respondent, not complete & not yet pas QC

thanks again

 

[Jacob Skaria]

Try modifying the previous one before trying the below....It is easy..

=A4 & ", " & IF(COUNTIF(B4:E4,B4)=4,B4+0&" respondent closed, already
completed and pass QC",C4+0&" from "&B4+0&" respondent, "& IF(D4<=0,"not
complete & ",D4&" complete & ") & IF(E4<=0,"not yet pass QC",E4&" pass QC"))

If this post helps click Yes

 

[reza]

wow...great again...
you really - really save my time for doing a work...
many thanks jacob