software

Start with this =AVERAGE(B7:M7) = 6.87%
and this =AVERAGE(B15:M15) = 6.65%
=(N7-N15)/N7
= 3.19%

Ok What happens I get a different Answer if I hard code the Averages aboveIt should be 3.20% and on a blank sheet it works. My main question is can
the average Formula on each line cause
the error because if I use the formula without the averages and hard code the
% on each line then use =(N7-N15)/N7 I get 3.20%

Help me understand what I am doing wrong. Thank you in advance for any help.

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.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Trudatquot; lt;u18243@uwegt; wrote in message news:5b241dbf211c2@uwe...
gt; Start with this =AVERAGE(B7:M7) = 6.87%
gt; and this =AVERAGE(B15:M15) = 6.65%
gt; =(N7-N15)/N7
gt; = 3.19%
gt;
gt; Ok What happens I get a different Answer if I hard code the Averages above
gt;
gt;
gt; It should be 3.20% and on a blank sheet it works. My main question is can
gt; the average Formula on each line cause
gt; the error because if I use the formula without the averages and hard code
the
gt; % on each line then use =(N7-N15)/N7 I get 3.20%
gt;
gt; Help me understand what I am doing wrong. Thank you in advance for any
help.
Bob Phillips wrote:
gt;It is probably because the values are not exactly 6.87 and 6.65, but you
gt;have the display at 2 dec places. Increase the dec places and re-do the
gt;calculation manually.
gt;
gt;gt; Start with this =AVERAGE(B7:M7) = 6.87%
gt;gt; and this =AVERAGE(B15:M15) = 6.65%
gt;[quoted text clipped - 9 lines]
gt;gt;
gt;gt; 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.Trudat wrote:
gt;gt;It is probably because the values are not exactly 6.87 and 6.65, but you
gt;gt;have the display at 2 dec places. Increase the dec places and re-do the
gt;[quoted text clipped - 5 lines]
gt;gt;gt;
gt;gt;gt; Help me understand what I am doing wrong. Thank you in advance for any help.
gt;
gt;I did change it out to 8 and same totals. The strange part is I can make
gt;this work when I put the values in with out the averages from the other lines.

You were right . I had went out to 8 digits on each line but not the total
field. Once the total field was out to 8 digits the spread sheet was right.
The average was correct at 3.19% not 3.20% Thank you for the help.

--
Message posted via www.officekb.com