balance in excel that only shows the last entry
 

I have a simple formula
in cell G4 I have =(g3-c4-d4-e4+f4)

When I copy it down for the entire column it shows the last "G" entry all
the way down. I want it blank until I fill in c4, d4,ef or f4 (like a
checkbook register, but with multiple columns)

balance in excel that only shows the last entry
 

Try this:

=IF(COUNT(C4:F4),G3-C4-D4-E4+F4,"")


--
Biff
Microsoft Excel MVP


"mchick" wrote in message
...
I have a simple formula
in cell G4 I have =(g3-c4-d4-e4+f4)

When I copy it down for the entire column it shows the last "G" entry all
the way down. I want it blank until I fill in c4, d4,ef or f4 (like a
checkbook register, but with multiple columns)

balance in excel that only shows the last entry
 

thanks so very much. I think I had tried everything but that :)

"T. Valko" wrote:

Try this:

=IF(COUNT(C4:F4),G3-C4-D4-E4+F4,"")


--
Biff
Microsoft Excel MVP


"mchick" wrote in message
...
I have a simple formula
in cell G4 I have =(g3-c4-d4-e4+f4)

When I copy it down for the entire column it shows the last "G" entry all
the way down. I want it blank until I fill in c4, d4,ef or f4 (like a
checkbook register, but with multiple columns)

balance in excel that only shows the last entry
 

You're welcome!

--
Biff
Microsoft Excel MVP


"mchick" wrote in message
...
thanks so very much. I think I had tried everything but that :)

"T. Valko" wrote:

Try this:

=IF(COUNT(C4:F4),G3-C4-D4-E4+F4,"")


--
Biff
Microsoft Excel MVP


"mchick" wrote in message
...
I have a simple formula
in cell G4 I have =(g3-c4-d4-e4+f4)

When I copy it down for the entire column it shows the last "G" entry
all
the way down. I want it blank until I fill in c4, d4,ef or f4 (like a
checkbook register, but with multiple columns)