EXCEL HELP

SPIDER, on Friday September 5, 2008 11:29:52 PM

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)

Configuration: Windows XP
Internet Explorer 7.0

Reply to SPIDER Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

canthave, on Saturday September 6, 2008 09:01:12 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

Reply to canthave

Ask your question Reply

Results for

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3

Excel tips : How to insert date In an Excel cell Excel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

Download Excel Viewer With Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer

1 2 3 Next

Results for

How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf

1 2 3 Next

Results for

Excel Macro Help Please (Solved)Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for the purpose of importing to a DB via an Excel CSV file. I have everything sitting in an excel file now with... en.kioskea.net/forum/affich-11146-excel-macro-help-please

Excel question - conditional format (Solved)Hello, I am trying to format excel file base on date. I have a excel file with lots rows in which a cell contains date info. I want to format it like this: If the date in the line is less than today, change the row to red; If the date is between today... en.kioskea.net/forum/affich-7133-excel-question-conditional-format

Excel autofilter stops filtering (Solved)Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. When I clicked the arrow there is no value... en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering

1 2 3 Next

Results for

Download ConnectCode Free Excel TrainingService Excel is an inevitable when they use Windows as Word is him. However her use is not of the most intuitive for the laymen. ConnectCode Free Excel Training is a program of study for introduction with Excel. It understands ten different... en.kioskea.net/telecharger/telecharger-568-connectcode-free-excel-training

1 2 3 Next