Use IF and nested IF logic

Use IF and nested IF logic in Google Sheets — with three ready prompts, from the immediate task to the lasting pattern.

3prompt heights
Open it in the interactive atlas →

3 ready prompts

Written for the moment this actually comes up.

Execute — do the immediate task

+
I have employee scores in column B and I need a new column C that classifies each as 'Low' for…
I have employee scores in column B and I need a new column C that classifies each as 'Low' for scores <60, 'Medium' for 60–79, and 'High' for 80 and above using IF and nested IF logic. Implement the formula in C2 and fill down for 500 rows on the sheet Performance. Label C1 'Rating'.

Improve — make it easier to accept

+
Before I share Performance with HR, make the IF logic transparent and reduce reviewer hesitation.…
Before I share Performance with HR, make the IF logic transparent and reduce reviewer hesitation. Add the rating in column C using nested IFs, include a comment next to the header explaining the thresholds, and create a small legend at the top showing the number of Low, Medium, and High. Also flag any out-of-range scores (below 0 or above 100).

Decide — diagnose the stuck moment

+
I created a Ratings column with nested IFs for Performance, and HR now says thresholds may shift…

I set up nested IFs but HR says the thresholds might change

I created a Ratings column with nested IFs for Performance, and HR now says thresholds may shift mid-cycle. I don't know whether to hard-code thresholds or make them reference cells. If I change to reference cells will it break existing formulas or reporting? What's the safest immediate change so thresholds can be adjusted without reworking downstream reports, and how should I communicate the change to HR and payroll?

Next to this one

Other spreadsheet work people do in Google Sheets.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.