How to divide some value specific number of times in different number of cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1798936%22%20slang%3D%22en-US%22%3EHow%20to%20divide%20some%20value%20specific%20number%20of%20times%20in%20different%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1798936%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3Eas%20it's%20written%20in%20subject%2C%20we%20are%20trying%20to%20divide%20some%20input%20value%20in%20different%20number%20of%20cells.%20For%20example%2C%20if%20input%20value%20in%20cell%20E11%20is%20200%24%20(COMPANY%20part)%2C%20formula%20should%20divide%20this%20amount%20on%20four%20equal%20parts%20in%20cells%20T11%2C%20U11%2C%20V11%2C%20W11%20(BUYER%20part).%20To%20be%20more%20specific%2C%20if%20payment%20was%20200%24%20in%20January%2C%20it%20should%20skip%20one%20month%20(February)%20and%20divide%20amount%20in%20March%2C%20April%2C%20May%20and%20June%20on%20four%20equal%20parts.%26nbsp%3B%20If%20payment%20was%20400%24%20in%20August%2C%20it%20should%20skip%20one%20month%20(September)%2C%20and%20divide%20amount%20in%20October%2C%20November%2C%20December%20and%20January%20(as%20you%20can%20see%2C%20when%20it%20reaches%20the%20end%20of%20year%2C%20it%20should%20bring%20back%20value%20to%20the%20first%20month%20of%20the%20year%2C%20some%20kind%20of%20loop).%20Is%20it%20possible%20to%20do%20with%20formula%2C%20or%20it%20shoud%20be%20done%20through%20VBA%3F%3C%2FP%3E%3CP%3EBest%20regards!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1798936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799067%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20divide%20some%20value%20specific%20number%20of%20times%20in%20different%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799067%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825945%22%20target%3D%22_blank%22%3E%40RadoSV%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%3C%2FP%3E%3CP%3EEven%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3EThis%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eand%20we%20could%20do%20the%20tests%20much%20faster%20on%20the%20dat%3C%2FSPAN%3E%3C%2FSPAN%3Ea...%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799111%22%20slang%3D%22en-US%22%3EBetreff%3A%20How%20to%20divide%20some%20value%20specific%20number%20of%20times%20in%20different%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20quick%20response.%20Of%20course.%20We%20are%20using%20Office%20365%20on%20Windows%2010%20OS.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

as it's written in subject, we are trying to divide some input value in different number of cells. For example, if input value in cell E11 is 200$ (COMPANY part), formula should divide this amount on four equal parts in cells T11, U11, V11, W11 (BUYER part). To be more specific, if payment was 200$ in January, it should skip one month (February) and divide amount in March, April, May and June on four equal parts.  If payment was 400$ in August, it should skip one month (September), and divide amount in October, November, December and January (as you can see, when it reaches the end of year, it should bring back value to the first month of the year, some kind of loop). Is it possible to do with formula, or it shoud be done through VBA?

Best regards!

2 Replies
Highlighted

@RadoSV 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.

Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

This would also be a blessing for all of us, as we can understand the problem much better and we could do the tests much faster on the data... win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.

 

 

Thank you for your understanding and patience

 

 

Nikolino

 

I know I don't know anything (Socrates)

Highlighted

@Nikolino,

 

thanks for quick response. Of course. We are using Office 365 on Windows 10 OS.