Re: Need help with formula

Kevin Williams wrote...
>I have put together a spread*** in Microsoft Works to track my "billable
>efficiency" on my job. In other words, I enter how many hours I worked, my
>billable hours, and I have embedded a formula to calculate what percentage
>of my billable hours are of my total. The problem is, on days when I didn't
>work, if I enter 0 for my hours, this generates an error, and I can't
>average my weekly. Any help would be appreciated.

Does Works include a function named IF? If so, and if hours worked were
in cell B3 and billable hours were in cell C2, then the formula in D3
could be

=IF(B3>0,C3/B3,0)

As for weekly averages, if B3 through C9 held a full weeks hours and D3
through D9 the daily efficiency figures, you shouldn't be calculating
the average weekly efficiency by averaging column D, you should be
dividing total billable hours by total hours worked, e.g.,

=IF(SUM(B3:B9)>0,SUM(C3:C9)/SUM(B3:B9),0)

The reason for this is best illustrated with an example. You work only
2 days. On Monday you work 10 hours of which 6 are billable. On Tuesday
you work 5 hours of which 4 are billable. Efficiency figures would be
60% for Monday and 80% for Tuesday. Averaging the percentages returns
70%, but taking the ratio of the totals gives 66.7%.

.