Jun 05 2020 12:42 PM
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?
Jun 05 2020 12:53 PM
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,"")