98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Calculations
excel microsoft training - Calculations
Resolved · Low Priority · Version Standard
Barbara has attended:
Excel Introduction course
Excel Intermediate course
Calculations
how do you work out the projected percentage of a target figure based on work produced so far; the target firgure also having an end date.
eg target at end date 156,000 - produced so far 94,000 -
RE: calculations
Dear Barbara
Thank you for attending Excel courses with us.
I am not clear of the question but I am assuming you simply want to know how much work has been done (%) depending on the expected figure and actual figure.
If that is what you are seeking then simply divide the actual work done by the expected target. To make sure it is in % I would format the resulting cell as percentage by choosing [b]Format> Cells
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create your own custom list on Excel 2010!If you know how to use the auto-fill option on Excel then why not create your own customs lists? |