IF Question

  • Thread starter Thread starter H
  • Start date Start date
H

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
 
H,

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

then copy down.

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

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



"H" escreveu:
 
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.
 
Back
Top