Checking Register

[Bob]

My formula is =H3-F6+I6

H3 contains my starting balance.

H Column labeled Balance

F Column labeled Debit

I Column labeled Credit


If the Balance is for example $1000, all of the rows below the last entry
show $1000 in the Balance column. I would like to duplicate the way an
actual checkbook register looks and have nothing displayed in those rows
until I input a debit or credit. How can I do that?

 

[Dave Peterson]

=if(count(f6,i6)=0,"",H3-F6+I6)

My formula is =H3-F6+I6

H3 contains my starting balance.

H Column labeled Balance

F Column labeled Debit

I Column labeled Credit

If the Balance is for example $1000, all of the rows below the last entry
show $1000 in the Balance column. I would like to duplicate the way an
actual checkbook register looks and have nothing displayed in those rows
until I input a debit or credit. How can I do that?

 

[Bob]

Thanks for the response Dave.

When I entered =if(count(f6,i6)=0,"",H3-F6+I6) all the cells in the Balance
column show #NAME?

 

[Dave Peterson]

I use a USA version of excel. And with USA settings.

If you use a different language, you'll have to share it--maybe someone can
help.

If your settings aren't for USA, you may have to change the commas to semicolons
(, becomes

In fact, you could try this:

Open a test workbook
select the cell that gets the formula (J6???).
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window.
Type this:
activecell.formula="=if(count(f6,i6)=0,"""",H3-F6+I6)"
and hit enter.

Then close the VBE window and go back to excel.

You'll see how the formula gets translated.

If you do use a USA version of excel with USA settings, I'm betting that you
mistyped the formula--or you were in R1C1 Reference style instead of A1
reference style.