Spreading an amount over a period of time based on predetermined %

R

RL

Hi,
Need help with the following scenario:
Column A: Amount
Column B: Classification
Column C: Date
Column D and on: January Thr December

I need to spread the amount on column A among the different months based on
a predetermined curve.

Say starting in column T, I set up 5 more columns named Classification, 30,
60, 90, 120. If the amount in Column A matches the classification set in
column T, I need to spread the amount based on the % indicated in column 30,
60, 90, 120 (which are the days passed from the date set in column C).

Can this be done?
Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Formula and Dates 4
Month days over a time period 5
Spread Project Costs Over Months Using Bell Curve 2
Sorting amounts in columns by due dates 7
Conditional Accounts receivable Aging Analysis 0
Complex problem in Lookup 0
I Need Calculate Variable Scenarios with timings 0
Calculating Elapsed Time Over a Set Period 2

Top