MAX & IF Formula's used in Telecom
Max formula used by many analyst and MIS executive to find out the key insight of the database. It helps them in segregation and targeting the database depends upon the usage of the customers.
Let us See the use of MAX formula to find out the high usage from the services utilized by demo database.
The below sheet represent some column with services utilized by customers for certain period.
All the Business strategies in telecom or any other similar sector depends on the usage of the customers, Telecom people call it as "ARPU" means Average Revenue Per Users is being most important element in the sector and lots of strategies can built to get the HIGH ARPU from their customers.
Calculating ARPU with available database is the easiest task one can do but get the category wise usage one needs MAX formula.As per the below sheet their are usage has given in the column against every subscriber/number.
Now, We have to find out the maximum usage from different categories.Let make use of MAX formula now.
Calculating ARPU with available database is the easiest task one can do but get the category wise usage one needs MAX formula.As per the below sheet their are usage has given in the column against every subscriber/number.
Now, We have to find out the maximum usage from different categories.Let make use of MAX formula now.
 |
| Demo Database |
1. Select the criteria from the sheet.
2. Write the MAX formula as =MAX(D4:I4) or =MAX(Select field)
3. Enter and then you will see the Max value from the usage.
4. Drag the formula and apply for rest cells in column.
2. Write the MAX formula as =MAX(D4:I4) or =MAX(Select field)
3. Enter and then you will see the Max value from the usage.
4. Drag the formula and apply for rest cells in column.
 |
| MAX Formula |
Though, We got the MAX usage from the list but now we will mentioned Maximum utilized service/product by using IF formula and complete the task for further analysis which can allow us to find out which product has been utilized max by the customers.
Hence, We will make use of IF formula in the below mentioned way and prepare the database for ARPU calculation on the basis of product/service utilized.
 |
| IF Formula |
1. Select the criteria from the sheet.
2. Write the IF formula as =IF(J4=D4,$D$3,IF(E4=J4,$E$3,IF(G4=J4,$G$3,IF(H4=J4,$H$3,$I$3))))
3. Enter and then you will see the Service/Product mentioned against the MAX usage.
4. Drag the formula and apply for rest cells in column.
If you work as a MIS Executive or Business Analysis in telecom or related industry these 2 formula's will help you to give you good information about your data and help you in analysis.
No comments:
Post a Comment