If Then program i think

[carrguy01]

I am looking to enter a dollar value in cell b7 and in cell b8 the instalment period EI payment number 5. I want my value to be entered into the coresponding instalment period. Payment 5 is e32.

I need the formula so that i can change the values in b7 and b8.
cell a b c e f g
7 lump payment $10000
8 month payment to be made 5

27 instalment monthly intrest extra pay bal total
28 1 108.33 711.62 _____ 234.. 71..

 

[carrguy01]

I got it to work here is the formula i appoligize i thought you understood i was working down not across

=(ROW($A$35:A35)=$B$8)*$B$7

 

[Scott Huish]

If you are putting a number like 1 to 5 etc in B8, you'll want to use ROWS not ROW