EXCEL HELP

Closed
SPIDER - Sep 5, 2008 at 06:29 PM
canthave Posts 34 Registration date Monday August 25, 2008 Status Member Last seen July 3, 2009 - Sep 6, 2008 at 04:01 AM
Hello,
I am trying to use excel to work out a statement for me as follows

I want a rolling average percentage based on the current month

I need the reference cell to look at the first month and place it in the ROLLING AVERAGE CELL RESULT
The as the next month gets data to add that month together then divide by 2 ( the number of months ) then when data is entered in the next month take that data and add it up then divide it by the number of months and so on for the next twelve months
I have used this for the first month


=IF(E4<0,0,(E4+F4)/2)
Related:

1 response

canthave Posts 34 Registration date Monday August 25, 2008 Status Member Last seen July 3, 2009 2
Sep 6, 2008 at 04:01 AM
hey spider,

just check the tips on the forum itself about what you are willing to do, in the excel macro examples..

hope you get it
0