Conditions on Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1443850%22%20slang%3D%22en-US%22%3EConditions%20on%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443850%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20building%20a%20spreadsheet%20that%20calculates%20funds%20in%20an%20account%20based%20on%20adding%20other%20accounts.%26nbsp%3B%20I've%20filled%20in%20a%20basic%20function%20%3DB2%2BB3%2C%20and%20filled%20in%20down%20the%20column%20so%20it%20will%20calculate%20each%20row%20automatically%2C%20but%20I%20don't%20want%20it%20to%20work%20the%20formula%20until%20I%20put%20numbers%20in%20the%20cells%20being%20added.%26nbsp%3B%20Right%20now%20it%20shows%200's%20down%20the%20column%2C%20and%20I%20want%20to%20have%20a%20condition%20that%20it%20won't%20fill%20until%20I%20put%20in%20numbers.%26nbsp%3B%20I%20have%20another%20function%20working%2C%20but%20I%20don't%20want%20it%20to%20calculate%20until%20I%20have%20filled%20in%20the%20cell%20just%20to%20the%20left%20of%20it.%26nbsp%3B%20Can%20I%20do%20that%20also%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1443850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1443876%22%20slang%3D%22en-US%22%3ERe%3A%20Conditions%20on%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162691%22%20target%3D%22_blank%22%3E%40Timothy%20Herndon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETwo%20options%20-%20don't%20care%20about%20calculations%20and%20apply%20custom%20number%20format%20as%20%3CSTRONG%3E%3B%3B%3B%3C%2FSTRONG%3E%20or%20like%20which%20will%20hide%20all%20zeroes.%20Or%20use%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(B2%2BB3%2CB2%2BB3%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445246%22%20slang%3D%22en-US%22%3ERe%3A%20Conditions%20on%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks-%20I'll%20give%20it%20a%20try.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

@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,"")
Highlighted

@Sergei Baklan 

Thanks- I'll give it a try.