Re: Help Please with %
- From: "Trudat" <u18243@uwe>
- Date: Mon, 30 Jan 2006 18:56:31 GMT
Bob Phillips wrote:
>It is probably because the values are not exactly 6.87 and 6.65, but you
>have the display at 2 dec places. Increase the dec places and re-do the
>calculation manually.
>
>> Start with this =AVERAGE(B7:M7) = 6.87%
>> and this =AVERAGE(B15:M15) = 6.65%
>[quoted text clipped - 9 lines]
>>
>> Help me understand what I am doing wrong. Thank you in advance for any help.
I did change it out to 8 and same totals. The strange part is I can make
this work when I put the values in with out the averages from the other lines.
.
- Follow-Ups:
- Re: Help Please with %
- From: Trudat via OfficeKB.com
- Re: Help Please with %
- References:
- Help Please with %
- From: Trudat
- Re: Help Please with %
- From: Bob Phillips
- Help Please with %
- Prev by Date: Re: YEAR function name not found
- Next by Date: Re: Problem calculating weekly costs
- Previous by thread: Re: Help Please with %
- Next by thread: Re: Help Please with %
- Index(es):
Relevant Pages
|