percentage

[Pam]

sample of sheet
Col-A B C D E F
Mon Tues Wed Thurs Fri Avg
week 1 5 8 4 3 7 5.4
week 2 14 5 8 2 3 6.4
week3 5 6 8 2 3 7.6
week4 8 1 2 3 5 3.8
total monthly average 5.8

question: I need to show a percentage of increase or
decease of the weekly averages.

 

[Don]

Hi Pam,

Try this:

Format Column G to "Percentage" then enter in G3 (if I'm
reading your chart right, row3 is the first occurence of
a decrease or increase):

=((F3-F2)/F2)

Copy this down Column G as needed

HTH,

Don