Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Please with %
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. |