Is there a way for me to group all of my sales info by price category? Not sure how I would write the formula.
IF[Price] < 1000000 THEN '<$1M'
IF [Price] > 1000000 AND <= 3000000 THEN '$1M-$3M'
You're close! Try
IF [Price] <1000000 THEN "<$1M"
ELSEIF [Price] >=1000000
Retrieving data ...