Forum Discussion
gregt40
Mar 01, 2022Copper Contributor
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")
Riny_van_Eekelen
Mar 01, 2022Platinum Contributor
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?