=IF(
New Member
- Joined
- Apr 20, 2010
- Messages
- 27
Hey guys,
Hoping you can help me with something I've had trouble with. I'm trying to assign a cash flow to the correct periods in time based on years & frequency. E.g
A5= Contract Start Date
B5= Contract Length (Specifically in years)
C5= Cost (to be evenly distributed for a period of time based on start date and contract length)
D5= Frequency in years (i.e. I only want the evenly distrubuted cost to occur every 3 years over a 20 year period)
Having a bit of trouble working this out but toying with the MOD function. Any ideas/ solutions?
Much appreciated!
Hoping you can help me with something I've had trouble with. I'm trying to assign a cash flow to the correct periods in time based on years & frequency. E.g
A5= Contract Start Date
B5= Contract Length (Specifically in years)
C5= Cost (to be evenly distributed for a period of time based on start date and contract length)
D5= Frequency in years (i.e. I only want the evenly distrubuted cost to occur every 3 years over a 20 year period)
Having a bit of trouble working this out but toying with the MOD function. Any ideas/ solutions?
Much appreciated!