FORMULA & SQL / CLEANUP

Sort numbers into Low, Medium and High.
Tested, not guessed.

The Excel and Google Sheets formula and the SQL query, each run on the rows below. Open this with your own data ↗

The example rows

Row	A: Region	B: Rep	C: Amount	D: Order Date	E: Status	F: Customer
2	North	Ana	1,200	2026-03-01	Paid	Jo Smith
3	South	Ben	450	2026-03-15	Open	Raj Patel
4	North	Cy	300	2026-04-02	Paid	Lee Wong
5	East	Ana	980.50	2026-04-20	Paid	Mia Ross
6	North	Ben	75	2026-05-05	Open	Jo Smith
7	West	Dee	1,640	2026-05-18	Paid	Sam Okoro

Excel

=IF(C2<500,"Low",IF(C2<1000,"Medium","High"))

If Amount (C2) is less than 500, then "Low", otherwise if Amount (C2) is less than 1000, then "Medium", otherwise "High".

Run on the example rows:

PostgreSQL

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

Run on the example rows:

region	rep	amount	order_date	status	customer	band
North	Ana	1200	2026-03-01	Paid	Jo Smith	High
South	Ben	450	2026-03-15	Open	Raj Patel	Low
North	Cy	300	2026-04-02	Paid	Lee Wong	Low
East	Ana	980.5	2026-04-20	Paid	Mia Ross	Medium
North	Ben	75	2026-05-05	Open	Jo Smith	Low
West	Dee	1640	2026-05-18	Paid	Sam Okoro	High

Other databases

MySQL

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

SQL Server

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

SQLite

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

BigQuery

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

Snowflake

SELECT *, CASE WHEN amount < 500 THEN 'Low' WHEN amount < 1000 THEN 'Medium' ELSE 'High' END AS band
FROM sales

Paste your rows into the free tool and it writes this for your columns, then runs it on your data before you copy it. Open the tool ↗