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

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

=LOOKUP(A9,{0;1000001;5000000},{"<$1M";"$1 - $4M";"+ $5M"})

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"H" escreveu:

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

Hi,

Here is a nifty alternative - create the following custom format:

[<1000000]"< $1M";[<4999999]"$1-$4M";"+$5M"

Select the cells with the number and choose Format, Cells, Number tab,
Custom and enter the above on the Type line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

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