Need help with 'IF' statement.

%3CLINGO-SUB%20id%3D%22lingo-sub-1570512%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20'IF'%20statement.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570512%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20trying%20to%20add%20an%20'IF'%20statement%20in%20Excel.%20I'm%20adding%20cells%20and%20want%20to%20show%20the%20sum%20of%20the%20cells%2C%20but%20if%20the%20sum%20result%20is%20zero%2C%20I%20want%20the%20cell%20to%20be%20blank.%20Is%20this%20possible%3F%20Thank%20you%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1570512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570585%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20'IF'%20statement.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751344%22%20target%3D%22_blank%22%3E%40Cheryl_6263%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20have%20been%20better%20to%20attach%20a%20sample%20workbook%20than%20a%20Word%20document%20with%20a%20picture%20that%20doesn't%20explain%20anything.%3C%2FP%3E%0A%3CP%3EBut%20you%20can%20change%20a%20formula%20such%20as%3C%2FP%3E%0A%3CP%3E%3DSUM(A2%3BH2)%3C%2FP%3E%0A%3CP%3Eto%3C%2FP%3E%0A%3CP%3E%3DIF(SUM(A2%3AH2)%3D0%2C%22%22%2CSUM(A2%3AH2))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I'm trying to add an 'IF' statement in Excel. I'm adding cells and want to show the sum of the cells, but if the sum result is zero, I want the cell to be blank. Is this possible? Thank you

 
 

 

1 Reply

@Cheryl_6263 

It would have been better to attach a sample workbook than a Word document with a picture that doesn't explain anything.

But you can change a formula such as

=SUM(A2;H2)

to

=IF(SUM(A2:H2)=0,"",SUM(A2:H2))