Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show a blank cell
Hi Everyone!
I'm currently making a budget with a running total. There are five columns - Date, Description, Deposits, Withdrawls and Running Total. My Running Total formula is pretty basic: =SUM(F6,D7,-E7) and currently goes all the way down the worksheet regardless of if there is entries in the row. I was curious is there was a formula that would show the Running Total if there was a description and would show a blank cell if there was not. Let me know if this is possible! Thank you, Tandy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show a blank cell
=IF(ISBLANK(A1),"",F6,D7,-E7)
replce A1 with the cell that description is in for that row. "Tandy" wrote: Hi Everyone! I'm currently making a budget with a running total. There are five columns - Date, Description, Deposits, Withdrawls and Running Total. My Running Total formula is pretty basic: =SUM(F6,D7,-E7) and currently goes all the way down the worksheet regardless of if there is entries in the row. I was curious is there was a formula that would show the Running Total if there was a description and would show a blank cell if there was not. Let me know if this is possible! Thank you, Tandy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show a blank cell
Hi,
=IF(B7="","",SUM(F6,D7,-E7)) Cheers! Jean-Guy "Tandy" wrote: Hi Everyone! I'm currently making a budget with a running total. There are five columns - Date, Description, Deposits, Withdrawls and Running Total. My Running Total formula is pretty basic: =SUM(F6,D7,-E7) and currently goes all the way down the worksheet regardless of if there is entries in the row. I was curious is there was a formula that would show the Running Total if there was a description and would show a blank cell if there was not. Let me know if this is possible! Thank you, Tandy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show a blank cell
=if(B2 = "","",sum(F6,D7,-E7))
"Tandy" wrote: Hi Everyone! I'm currently making a budget with a running total. There are five columns - Date, Description, Deposits, Withdrawls and Running Total. My Running Total formula is pretty basic: =SUM(F6,D7,-E7) and currently goes all the way down the worksheet regardless of if there is entries in the row. I was curious is there was a formula that would show the Running Total if there was a description and would show a blank cell if there was not. Let me know if this is possible! Thank you, Tandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) |