quillmaster
New Member
- Joined
- Feb 28, 2013
- Messages
- 8
Hi,
i have some data of no of calls and i am trying to seggreage them based on the number of minutes spent on them, i am using nested if condition but it is giving me problems
can somebody help.
<tbody>
</tbody>the above formula is giving me 3 in every coloum....can anybody correct this.
i want to categories the seconds on the left most coloum to be categorised into right most coloum of i minute call ( between 0-59 sec), 2 minute call (60 to 119 sec), 3 minute calls ( 120 to179 sec) etc.
i have some data of no of calls and i am trying to seggreage them based on the number of minutes spent on them, i am using nested if condition but it is giving me problems
can somebody help.
146 | =IF(AND(D1)<59,1,IF(AND((D1)>59,(D1)<119),2,IF(AND((D1)>119,(D1)<179),3,IF(AND((D1)>179,(D1)<240),4,5)))) | 3 |
68 | ||
189 | ||
248 | ||
112 |
<tbody>
</tbody>
i want to categories the seconds on the left most coloum to be categorised into right most coloum of i minute call ( between 0-59 sec), 2 minute call (60 to 119 sec), 3 minute calls ( 120 to179 sec) etc.