# Declining balance,hide totals until...

1. ## 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.

2. 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.

3. Works like a charm!

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1