Formula/function to evenly distribute revenue over a variable number of months??

%3CLINGO-SUB%20id%3D%22lingo-sub-1299311%22%20slang%3D%22en-US%22%3EFormula%2Ffunction%20to%20evenly%20distribute%20revenue%20over%20a%20variable%20number%20of%20months%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299311%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20friends%20-%20I%20am%20looking%20for%20advice%20on%20how%20to%20program%20a%20revenue%20recognition%20schedule.%20The%20idea%20is%20pretty%20simple%20but%20I'm%20stumped%20on%20the%20solution.%20I%20need%20to%20be%20able%20to%20enter%20the%20%23%20of%20months%20over%20which%20I%20want%20to%20recognize%20revenue%20and%20have%20it%20be%20even%20distributed%20horizontally%20over%20that%20many%20months.%20Let's%20say%20I%20have%20%2412%2C000%20to%20recognize.%20I%20want%20to%20be%20able%20to%20enter%20%226%22%20as%20the%20%23%20of%20months%2C%20and%20then%20have%20%242%2C000%20populate%20over%206%20months.%20Or%20if%20I%20enter%20%2212%22%20for%20the%20%23%20of%20months%2C%20it%20will%20populate%20%241%2C000%20over%2012%20months.%20I've%20attached%20simple%20screenshots%20to%20show%20what%20outcome%20I%20am%20looking%20for.%20Any%2Fall%20assistance%20appreciated.%20Thank%20you!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-04-10%20at%2010.44.39%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183695i5E089A6971CBC906%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-04-10%20at%2010.44.39%20PM.png%22%20alt%3D%22Screen%20Shot%202020-04-10%20at%2010.44.39%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-04-10%20at%203.47.27%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183696i4E1331AE6DE84FBA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-04-10%20at%203.47.27%20PM.png%22%20alt%3D%22Screen%20Shot%202020-04-10%20at%203.47.27%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1299311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1299386%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%2Ffunction%20to%20evenly%20distribute%20revenue%20over%20a%20variable%20number%20of%20months%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299386%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F617600%22%20target%3D%22_blank%22%3E%40swilkenburn%3C%2FA%3E%26nbsp%3BThat%20would%20be%20like%20in%20the%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1300190%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%2Ffunction%20to%20evenly%20distribute%20revenue%20over%20a%20variable%20number%20of%20months%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Yes-%20that%20is%20exactly%20what%20I%20was%20looking%20for.%20I%20can't%20thank%20you%20enough!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello friends - I am looking for advice on how to program a revenue recognition schedule. The idea is pretty simple but I'm stumped on the solution. I need to be able to enter the # of months over which I want to recognize revenue and have it be even distributed horizontally over that many months. Let's say I have $12,000 to recognize. I want to be able to enter "6" as the # of months, and then have $2,000 populate over 6 months. Or if I enter "12" for the # of months, it will populate $1,000 over 12 months. I've attached simple screenshots to show what outcome I am looking for. Any/all assistance appreciated. Thank you!Screen Shot 2020-04-10 at 10.44.39 PM.pngScreen Shot 2020-04-10 at 3.47.27 PM.png

2 Replies
Highlighted

@swilkenburn That would be like in the attached workbook.

 

 

 

Highlighted

@Riny_van_Eekelen  Yes- that is exactly what I was looking for. I can't thank you enough!