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.