IF formulas

  • Thread starter Thread starter reza
  • Start date Start date
R

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
 
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
 
wow...great...

many many thanks....

reza

Jacob Skaria said:
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
Click to expand...
 
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
 
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
 
wow...great again...
you really - really save my time for doing a work...
many thanks jacob
 
Back
Top