Need a formula to distribute a value along a bell curve.

[XanderB]

Hey everyone! I'm trying to find a formula that would spread out a value amongst multiple cells along a bell curve.

Say I have $x,xxx. I want to spread that amount out in a certain proportion, regardless of how many cells I'm spreading it throughout.

Say I have a $10,000 project. I want to be able to spread it out like a bell curve in the cells I choose. For instance, if it was a five month project it would be distributed as
January - $1,000
February - $2,500
March - $3,000
April - $2,500
May - $1,000

If I added another month it would change to
January - $833.33
February - $1,666.66
March - $2,500.00
April - $2,500.00
May - $1,666.66
June - $833.33

I already thought of manually adding percentages to each cell, but the formula needs to be dynamic.

Thanks!

 

[XanderB]

Nevermind I solved my problem!

 

[kmp526]

If you figured it out, I'd love to know the answer.

I'm having a similar problem!

Thanks.

 

[Sal Paradise]

I'd love to know how he solved it considering he's only providing 2 parameters for a function that needs 3 (bell curves). You'd do it using the NORMDIST() function, I'd assume, but you'd need to determine the SD first. It'd probably be easier just to determine how you want it distributed first and then write formulas to use those percentages, because otherwise...

 

[XanderB]

=IF(relMo>nMos, "", ( NORMDIST(relMo, nMos/2, Dev, TRUE) - NORMDIST(A6, nMos/2, Dev, TRUE) ) * TotAmt * Factor )