Please can you help with "phasing"

[HerniaBay]

Hi Everyone

I am trying to split a given number over a set number of months.

Eg. If I had $30 and I wanted to split it over 5 months then I would have $6 per month.

I'm trying to show this in different displays and I am looking for the values to change automatically if I change either the amount or the length.

There is a second level to this where I would like to highlight the start month.

Any help would be appreciated as I AM STUCK!!!

happy to upload a file if I need to / am able to!

 

[Pitchblend]

<TABLE style="WIDTH: 730pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=972><COLGROUP><COL style="WIDTH: 108pt" span=3 width=144><COL style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 4320" span=2 width=270><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 108pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 width=144>Cell C4 30
Cell D4 5
Cell E4 formula =$C$4/$D$4

Cell F4 formula

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 108pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=144></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 108pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=144></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 203pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=270></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 203pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=270></TD></TR></TBODY></TABLE>
=IF(SUM(E4)<=$C$4,$C$4/$D$4,"")

Cell G4 formula
=If(Sum(E4:F4)<=$C$4,$C$4/$D$4,"")