Re: Help Please with %

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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.

.



Relevant Pages

  • Re: Newbie: Making objects transparent/opaque in LightWave 3D 8.0
    ... That is very strange. ... Even tho I see now some pieces were ... flipped I think they shouldn't display in a different color. ... Prev by Date: ...
    (comp.graphics.apps.lightwave)
  • Re: leading zeros in excel
    ... Bob Phillips ... > I need to display leading zeros in whole numbers eg 05324 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Image::Magick Annotate
    ... I have one strange - yet simple problem ... but the option Annotate is not working for me at all - rest is working fine.. ... do i need to install anything more or how can i display the annotate option ... Prev by Date: ...
    (perl.beginners)
  • Re: time sum incorrect
    ... because the display format is only one decimal place. ... in the email address with gmail if mailing direct) ... Bob Phillips wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Strange IIS Problem
    ... a strange thing has happened ... >> display the image. ... > Any entries in the IIS log file? ...
    (microsoft.public.inetserver.iis)