displaying a calculation after it's been calculated

[Learning]

I have a balance column that I want to only display the results after the
calculation has been completed. I don't want to see the zeros or the last
result all the way down the column

 

[Arvi Laanemets]

Hi

=IF(OR(Ref1="",Ref2="",...),"",BalanceFormula)

 

[Guest]

=IF(A1="","","Data you want to see")
IF(Test,valueIfTrue,ValueifFalse)