Conditions on Formulas

Copper Contributor

I am building a spreadsheet that calculates funds in an account based on adding other accounts.  I've filled in a basic function =B2+B3, and filled in down the column so it will calculate each row automatically, but I don't want it to work the formula until I put numbers in the cells being added.  Right now it shows 0's down the column, and I want to have a condition that it won't fill until I put in numbers.  I have another function working, but I don't want it to calculate until I have filled in the cell just to the left of it.  Can I do that also?

 

2 Replies

@Timothy Herndon 

Two options - don't care about calculations and apply custom number format as ;;; or like which will hide all zeroes. Or use formula like

=IF(B2+B3,B2+B3,"")

@Sergei Baklan 

Thanks- I'll give it a try.