Using The Left Formula In Excel

Do you happen to have well meaning people in your office who just don't get Microsoft excel

??

In their effort make life as easy for you as possible, they end up making it a lot more complicated?

Here's an example that might seem all too familiar to you. Your boss has just finished reviewing the sales (in 2009) of each person in your sales team. Based on their experience, and his gut feel, he has assigned sales targets for everybody in 2010. These are expressed as percentages of sales achieved in 2009. This data is shown below. He wants you to get at the actual sales targets.


Share:

In order to compute the sales target, you'd ideally want to multiply the numbers in the second column with those in the third. Except that you can't.

You can't do this because your boss has entered each data point as a text (" 180% of Last Year"). So what you're going to have to do is manually look up each number, and enter it as a formula in the adjoining cell.



Now, there are only nine people in this hypothetical example, but imagine a sales team that comprises of say, 200 people. Problem? Late night at the office? Frustration all round?


by: Excel Everest

POST COMMENT

Revitol Spot Gel - Stop the Suffering Now Kenstar Nce 173 Refrigerators 6 Objectives of Green Building A Wish To Catch A Fish In Dogwood Canyon Eat Too Much Moon cakes?——Hawthorn Can Promote Digestion Traits To Look For In Caretakers For The Elderly Hybrid-A Well Known Arm Time For My Teguise These are The End Times This Land Is Volcanic! Benefits Of Directory Submissions Tiagua Or Not Tiagua? That Is The Question. One Way Links As An Influential Tool