Allocating a Value
 

I need to allocate a specific value over a specific quarter based on the
date a user enters into Excel and the number of months the user wants
to allocate the value over. For example, if the user enters $300,000,
03/01/05 and 5 months into 3 independent data entry cells (A1,B1,C1
respectively) in a worksheet, I want the result to show up in Excel as:

Quarter 1 Quarter 2 Quarter 3
$60,000 $180,000 $60,000

Does anyone know of a formula that would accomplish this? I
appreciate your assistance.

Raymond

Looks like your allocating 1 month to Q1-- 3 months to Q2 --and 1 month to
Q3. Stands to reason Q2 would get 3 months but what if your number were six?

Don't know how a formula would know if Q1 got 1 or 2 months of the
allocation.


"Raymond Gallegos" wrote in
message ...
I need to allocate a specific value over a specific quarter based on the
date a user enters into Excel and the number of months the user wants
to allocate the value over. For example, if the user enters $300,000,
03/01/05 and 5 months into 3 independent data entry cells (A1,B1,C1
respectively) in a worksheet, I want the result to show up in Excel as:

Quarter 1 Quarter 2 Quarter 3
$60,000 $180,000 $60,000

Does anyone know of a formula that would accomplish this? I
appreciate your assistance.

Raymond