Forum Discussion
Excel
I would like to improve a formula too long can you help me .
(b4-c4-b7-c7-c9-c9-c9-b11-c11-b13-c13-b15-c15)/(f4-f7-f9-f11-f13-f15)
Every month there is an addition and a division to give an average that drops every month but I have to keep them all every month. what this addition is b17-c17-b19-c19 and for the division f17-f19 and so on .
Thank you for your help
Jean-Guy
1 Reply
- This is definitely a case where you'll help anybody who wants to help by uploading a copy of your spreadsheet. It's very likely that there's a MUCH simpler way to accomplish what you're trying to do, but without seeing the context it's next to impossible to give suggestions.
It would also help (in case it's not obvious from the spreadsheet itself) if you could explain briefly what the "business purpose" is--meaning, even if it isn't literally a business situation, what is the underlying reality here, what the numbers represent, and what this average is supposed to tell you.
