Hi everyone,
I'm having trouble with some formula. I had another post with some of them and Ali helped me out but I have some others..
So, basically I know what questions these formulas are supposed to answer, and what they're actually doing. What kind of information are they about to show up, but I need to read them.. and i cannot!!
If anyone can help:
1.Calls per Task
=IF(J2<>"",1,0)+IF(H2<>"",1,0)+IF(L2<>"",1,0)
2.Total Reached
=IF(J2="Erreicht",1,0)+IF(H2="Erreicht",1,0)+IF(L2="Erreicht",1,0)
3.Date Approach 1
=IF(I2="","",IF(ISERROR(DATE(LEFT(I2,4),MID(I2,6,2),MID(I2,9,2))),DATE(MID(I2,7,4),MID(I2,4,2),LEFT(I2,2)),DATE(LEFT(I2,4),MID(I2,6,2),MID(I2,9,2))))
4.Timevalue Approach 1
=IF(I2<>"",TIMEVALUE(MID(I2,12,5)),"")
5.Calls made on the selected day
=IF(Q2='Daily Metrics'!$I$4,1,0)+IF(S2='Daily Metrics'!$I$4,1,0)+IF(U2='Daily Metrics'!$I$4,1,0)
6.Total Reached on the selected day
=IF(AND(Q2='Daily Metrics'!$I$4,H2="Erreicht"),1,0)+IF(AND(S2='Daily Metrics'!$I$4,J2="Erreicht"),1,0)+IF(AND(U2='Daily Metrics'!$I$4,L2="Erreicht"),1,0)
7.Reached calls from 8 to 11
=IF(AND(TIME(8,0,0)<=$R2,TIME(11,0,0)>$R2,$H2="Erreicht"),1,0)+IF(AND(TIME(8,0,0)<=$T2,TIME(11,0,0)>$T2,$J2="Erreicht"),1,0)+IF(AND(TIME(8,0,0)<=$V2,TIME(11,0,0)>$V2,$L2="Erreicht"),1,0)
8.Reached calls from 11 to 14
=IF(AND(TIME(11,0,0)<=$R2,TIME(14,0,0)>$R2,$H2="Erreicht"),1,0)+IF(AND(TIME(11,0,0)<=$T2,TIME(14,0,0)>$T2,$J2="Erreicht"),1,0)+IF(AND(TIME(11,0,0)<=$V2,TIME(14,0,0)>$V2,$L2="Erreicht"),1,0)
9.Reached calls from 14 to 17
=IF(AND(TIME(14,0,0)<=$R2,TIME(17,0,0)>$R2,$H2="Erreicht"),1,0)+IF(AND(TIME(14,0,0)<=$T2,TIME(17,0,0)>$T2,$J2="Erreicht"),1,0)+IF(AND(TIME(14,0,0)<=$V2,TIME(17,0,0)>$V2,$L2="Erreicht"),1,0)
10.Reached calls from 17 to 20
=IF(AND(TIME(17,0,0)<=$R2,TIME(20,0,0)>$R2,$H2="Erreicht"),1,0)+IF(AND(TIME(17,0,0)<=$T2,TIME(20,0,0)>$T2,$J2="Erreicht"),1,0)+IF(AND(TIME(17,0,0)<=$V2,TIME(20,0,0)>$V2,$L2="Erreicht"),1,0)
Thank you much!
Bookmarks