IF Question

[H]

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

 

[Bernie Deitrick]

H,

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

then copy down.

HTH,
Bernie
MS Excel MVP

 

[Marcelo]

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

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



"H" escreveu:

 

[Shane Devenshire]

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.