[Solved] Make a formula cell blank

[TxWarren]

Greetings,

On a simple checkbook Calc Spreadsheet, I would like the Balance column blank EXCEPT for the current cell/balance. Once I add a transaction, the new balance should appear.

Is there an ISBLANK IF formula?

Thank you in advance.

[RusselB]

You can't use a formula to make a cell return a literal blank.
You can use a formula that will return something that makes the cell appear blank.

There is an ISBLANK function, which can be combined with the IF function.
Personally, I use

Code: Select all

=if(and(e3="";f3="");"";sum($f$2:$f3)-sum($e$2:$e3))

in G3
column references have been adjusted for what you show in the picture, but row references may need to be adjusted for your actual rows

Personally I like using the ="" rather than ISBLANK. If you prefer to use ISBLANK then the above formula would become

Code: Select all

=if(and(isblank(e3);isblank(f3));"";sum($f$2:$f3)-sum($e$2:$e3))

[TxWarren]

Thanks, Worked great!

Warren