Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Calculations

excel microsoft training - Calculations

ResolvedVersion Standard

Tue 22 Jan 2008, 09:16 Delegate Barbara said...

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 -

Mon 4 Feb 2008, 16:27 Trainer Rajeev said...

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