IF Statement

[Geeoff]

Hi, I am trying to get this IF statement to work. Here is the thing...

=if(B:B=(1-34),"***",if(B:B=(35-48),"$$$",if(B:B=(49-54),"###","Nothing")))

As you can see in my formula, I can't figure out the way to have Excel
recognize the "value range" as a number (i.e. range of values -->
B:B=(1-34)). Can you please tell me the best way to achieve this? Perhaps a
different function? Thanks for helping me out.

 

[CLR]

=IF(AND(MIN(B:B)=1,MAX(B:B)=34),"***",IF(AND(MIN(B:B)=35,MAX(B:B)=48),"$$$",
IF(AND(MIN(B:B)=49,MAX(B:B)=54),"###","Nothing")))

All one string...........watch out for the wordwrap...........

Vaya con Dios,
Chuck, CABGx3