Conditional Logic
IF, IFS, AND, OR — build status flags and pass/fail rules.
conditional logic
Highlight Duplicate Values With Color
Use a COUNTIF rule in conditional formatting to automatically color every cell whose value appears more than once.
=COUNTIF($A$2:$A$20,A2)>1conditional logic
Highlight Overdue Rows Automatically
A conditional formatting rule that colors the whole row when a due date has passed and the task still isn't marked Complete.
=AND($B2<TODAY(),$C2<>"Complete")conditional logic
Create a Pass/Fail Status Column
Turn a score column into clear Pass or Fail labels with a single IF — the simplest and most-used conditional formula there is.
=IF(B2>=70,"Pass","Fail")conditional logic
Create a Status with Multiple Conditions
Grade scores into Excellent, Pass, or Fail with IFS — cleaner than nested IFs, with a TRUE catch-all so nothing slips through.
=IFS(B2>=90,"Excellent",B2>=70,"Pass",TRUE,"Fail")conditional logic
Catch Any Formula Error With IFERROR
Wrap a risky calculation in IFERROR to swap any error for a fallback like 0 — keeping totals, charts, and reports working.
=IFERROR(A2/B2,0)