IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-3223884%22%20slang%3D%22en-US%22%3EIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223884%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20has%20some%20simply%20if%20statements%20that%20return%20the%20statements%20as%20true%20when%20I%20know%20they%20the%20cell%20should%20return%20a%20false.%20Are%20these%20corru%3C%2FP%3E%3CP%3E%40if(AB34%3D%22stemwall%22%2C%20%22footing%22%2C%22toedown%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3223884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3223905%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1320331%22%20target%3D%22_blank%22%3E%40gregt40%3C%2FA%3E%26nbsp%3BThe%20formula%20%3D%3CSPAN%3Eif(AB34%3D%22stemwall%22%2C%20%22footing%22%2C%22toedown%22)%20has%20correct%26nbsp%3B%3C%2FSPAN%3Esyntax.%20You%20can%20remove%20the%20%40-sign%2C%20by%20the%20way.%26nbsp%3BIf%20cell%20AB34%20is%20equal%20to%20the%20word%20%3CEM%3Estemware%3C%2FEM%3E%20it%20will%20return%20%3CEM%3Efooting%3C%2FEM%3E%2C%20otherwise%20%3CEM%3Etoedown%3C%2FEM%3E.%20Isn't%20that%20what%20you%20want%3F%20Can%20you%20show%20the%20formula%20%22in%20action%22%20in%20a%20screenshot%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3224045%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3224045%22%20slang%3D%22en-US%22%3EIt%20should%20work%20fine%2C%20unless%20you%20have%20a%20spelling%20mistake%2C%20or%20you%20are%20checking%20wrong%20cell%20AB34%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a spreadsheet that has some simply if statements that return the statements as true when I know they the cell should return a false. Are these corru

@if(AB34="stemwall", "footing","toedown")

2 Replies

@gregt40 The formula =if(AB34="stemwall", "footing","toedown") has correct syntax. You can remove the @-sign, by the way. If cell AB34 is equal to the word stemware it will return footing, otherwise toedown. Isn't that what you want? Can you show the formula "in action" in a screenshot?

It should work fine, unless you have a spelling mistake, or you are checking wrong cell AB34