Declining balance,hide totals until...

I am trying to create a formula that will take a beginning balance, subtract another number and present a total. This will take up 2 columns (# to subtract and balance remaining) and 16 rows (for entry of $).

I would like to fill the formula down the balance column of all 16 rows, but not have the total show until there is a number in the first column rather than just a list of the same total number all the way down the column.

BUDGET AMT: 500.00

PURCHASE....DECLINING
AMOUNT...... BALANCE
...25.00.....475.00
............... 475.00....I would like to see this cell blank until a number is entered to the right.
............... 475.00
............... 475.00
............... 475.00
............... 475.00
............... 475.00

Thanks to any that can help.

Originally Posted by AlmostAGeek

I am trying to create a formula that will take a beginning balance, subtract another number and present a total. This will take up 2 columns (# to subtract and balance remaining) and 16 rows (for entry of $).

I would like to fill the formula down the balance column of all 16 rows, but not have the total show until there is a number in the first column rather than just a list of the same total number all the way down the column.

BUDGET AMT: 500.00

PURCHASE....DECLINING
AMOUNT...... BALANCE
...25.00.....475.00
............... 475.00....I would like to see this cell blank until a number is entered to the right.
............... 475.00
............... 475.00
............... 475.00
............... 475.00
............... 475.00

Thanks to any that can help.

See attached picture:

A. B1 is budget amount.

B5

=IF(A5<>"",LOOKUP(9.9999999999999E+307,$B$1:B4)-A5,"")

Enter and copy down.

B. B4 is budget amount.

B5

=IF(A5<>"",B4-A5,"")

Enter and copy down.

Hope this helps.

Works like a charm!

Thanks to you and this forum - life savers - all of you!