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
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)
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:
- EXCEL HELP
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
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
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
just check the tips on the forum itself about what you are willing to do, in the excel macro examples..
hope you get it