Tuesday 22 October 2013

6. Consider a scenario of MSP Telecom BPO,which works for its clients to sell their products. Linda, the Project Manager,is currently handling a project to sell the electronic products of KGElectronics. Currently, there are 10 members working for this project underLinda. Each member is required to sell 25 products at the end of each day.Linda maintains a Microsoft Excel worksheet to record the daily sales of eachteam member. At the end of the month, she wants to know whether the teammembers have achieved their daily targets. You are required to help Linda toaccomplish the task.

=IF(AND(K3>25,K4>25,K5>25,K6>25,K7>25,K8>25,K9>25,
K10>25,K11>25,K12>25,K13>25,K14>25,K15>25,K16>25,
K17>25,K18>25,K19>25,K20>25,K21>25,K22>25,K23>25,
K24>25,K25>25,K26>25,K27>25,K28>25,K29>25,K30>25,
K31>25,32>25),"Target Achieved","Taget not Achieved")



Home('Fill' tab  'Right')

No comments:

Post a Comment