Filling cells depending on two conditions

  • Thread starter Thread starter dziw
  • Start date Start date
D

dziw

I have worksheet for periodical (serial) payments.
Column A - payment starting date, in each row different, formated as
"dd.mm.yyyy"
Column B - type of payment (yearly, biannualy, quarterly, monthly)
Column C - amount of periodical payment
Columns D to ?? - range of months, eg. for 5 years, formated as "mmmm
yy"

What I need is to copy amount (eg. C2) to each respective column D-??
depending on type of payment and starting date.

How ? :)
 

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

Amortization w/ variable interest rate 1
Averaging many non-contiguous cells if they are blank 1
[CSE] SUM Array Formula with if condition 1
How can I define date range criteria in SUMIF formula? 1
Calculating Previous Pay Dates 8
Conditional formatting 5
mortgage ammortization schedule 7
Need formula that will sum cells in a column bases on criteria in other cells. 3

Back
Top