IF function

Copper Contributor

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