Thread: IF Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
Posts: 57
Default IF Question

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