Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have a spreadsheet that tallies expenses against the budget. I have set up the following formula to show as a blank until an entry has been made: =IF(D10=" "," ",G9-D10) The problem is that it does not show a blank value, rather, it continues to tally the total from the previous cell. See below: D E F G H 9 $850 $650 $1,500 $13,250 $18,428 10 $13,250 $18,428 11 $13,250 $18,428 Any suggestions how to keep the G and H columns blank until there is an entry in either D or E? Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding blank cells | Excel Discussion (Misc queries) | |||
Copying to blank cells | Excel Discussion (Misc queries) | |||
Summing (or counting) cells until there is a blank cell | Excel Discussion (Misc queries) | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions |