Forum Discussion
IF function
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
- It should work fine, unless you have a spelling mistake, or you are checking wrong cell AB34
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?
