H,

=IF(A1<1000000,"< $1M",IF(A1=5000000,"+$5M","$1-$4M"))

then copy down.

HTH,
Bernie
MS Excel MVP


"H" wrote in message
...
Hi :) Is there a way to create an IF statement that will categorize a column

IF A1 = < $1,000,000 then < $1M
IF A1 = $1,000,000 - $4,999,999 then $1-$4M
If A1 = $5,000,000 then +$5M

Thanks