The IF then formula is the classic conditional. If a test is true, return one thing. If it is false, return another. The pattern is IF(condition, value if true, value if false).
It shines on exact tests. Numbers, dates, and matching text are its home turf. The trouble starts when your condition is about meaning.
The Old Way (IF and Nested IFS)
A basic threshold check reads cleanly. Over 100 is High, otherwise Low.
=IF(A2>100, "High", "Low")Several branches means IFS, which lists condition and result in pairs. It is readable until the conditions stop being exact.
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", TRUE,"F")Now try "if this support ticket sounds urgent, flag it." IF cannot judge tone. You end up faking it with a REGEXMATCH keyword list, which misses anything you did not think to type.
The FITS Way (An IF That Reads Meaning)
FITS lets you write the condition and the outcomes as one plain-English sentence. It judges the cell, then returns your chosen label.
=FITS("If this ticket sounds urgent, return Escalate, otherwise return Normal: " & A2)You keep IF then thinking. There is a condition, a then, and an else. The difference is that FITS reads the words instead of matching them exactly.
=FITS("If this reply confirms the meeting, return Yes, if it declines return No, otherwise return Unclear: " & A2)When to Use Each
For numbers, dates, and exact matches, native IF and IFS are instant and free, so keep using them. Bring in FITS when the condition depends on tone, intent, or category that only a human could judge. This is the same building block behind sentiment analysis in Google Sheets and the single AI formula that replaces a pile of nested logic. For the full set of jobs it covers, read automating Google Sheets tasks you used to need regex for.
An IF Then That Understands the Cell
FITS adds a plain-English conditional to Google Sheets. Judge tone, intent, and category without a brittle keyword list. Free tier included.