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 above


It 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.