IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3088708%22%20slang%3D%22en-US%22%3EIF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088708%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20please%20could%20you%20tell%20me%20what's%20wrong%20with%20this%20formula%3A%26nbsp%3B%3DIF(SUM(D12%3AG12)%3DC12%2C''Balanced''%2C''Check'')%3C%2FP%3E%3CP%3Eit's%20keep%20coming%20up%20with%20an%20error%20message%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3088708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3088740%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1291419%22%20target%3D%22_blank%22%3E%40Natalia700%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20texts%20please%20use%20%3CFONT%20size%3D%225%22%20color%3D%22%23DF0000%22%3E%3CSTRONG%3E%22%3C%2FSTRONG%3E%3C%2FFONT%3E%20instead%20of%20double%20%3CFONT%20size%3D%225%22%20color%3D%22%23DF0000%22%3E%3CSTRONG%3E'%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3088731%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1291419%22%20target%3D%22_blank%22%3E%40Natalia700%3C%2FA%3E%26nbsp%3BIt%20seems%20you%20have%20used%20pairs%20of%20single%20quotes%20around%20the%20words%20Balanced%20and%20Check.%20You%20should%20use%20regular%20quotation%20marks%20(i.e.%20double-quotes).%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, please could you tell me what's wrong with this formula: =IF(SUM(D12:G12)=C12,''Balanced'',''Check'')

it's keep coming up with an error message

3 Replies

@Natalia700 It seems you have used pairs of single quotes around the words Balanced and Check. You should use regular quotation marks (i.e. double-quotes).

@Natalia700 

For the texts please use " instead of double '

 

thank you, I almost cried here why this doesn't work and the solution is so simple