ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Filling cells depending on two conditions (https://www.excelbanter.com/excel-worksheet-functions/46712-filling-cells-depending-two-conditions.html)

dziw

Filling cells depending on two conditions
 

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 ? :)


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=469843


dziw


nobody can help me ? thx in advance


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=469843



All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com