Repeat Value X given times

[rafaelcpaiva]

So I'm working on my new financial control excel sheet,
And while working on it I came across this problem:

I want that every time I put a financing program, let's say I paid something in 3 parcels, I want the formula to get the full price, divide it by 3 and then repeat it 3 times down:

parcels...full price....parcel
1 / 3.......$ 900,00.......x
2 / 3..........................x
3 / 3..........................x

I want that instead of X, a formula gives me $ 300,00 because that is the parcel I should pay this month
Anyone can figure this out? :D
Thanks so much

[ajryan88]

Hi,

Something like this? Formula in the blue cells.

I hope this helps

[martindwilson]

using ajryn88 example in c2 filled down

=IF(A2="","",IF(B2="",C1,B2/A2))

[ajryan88]

Oh that is a lot more straightforward!