| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list shows first blank row after last list entry | Excel Discussion (Misc queries) | |||
| Excel-Input numeric value in cell, it shows up as 1/100th of entry | Excel Discussion (Misc queries) | |||
| Cell Shows no Color until Data Entry | Excel Discussion (Misc queries) | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| automatic entering Balance at every entry in my bank account | Excel Discussion (Misc queries) | |||
Linear Mode
