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...
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.
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.