Distribution/Allocation of value

[FalconFlyer]

I am looking to distribute an amount over several employees as a bonus. I have a different percentage I would like to give each employee. How would I go about this? For example, I want to distribute $1,000 over 5 employees. TIA!

 

[Special-K99]

Base something on this

In A1:A5 put the employees names
In B1:B5 put the employees percentages (to distribute exactly $1000 between the employees the percentages should add up to 100%)

in C1
=B1*1000
and copy down to C5

 

[FalconFlyer]

Thank you for your reply. Not exactly what I was looking for, but realize I didn't explain it well enough. Let me think about it. Thanks again.