Hi, I'm trying to to get excel to return the value of a cell based on a number in another cell. Basically, I need it to return certain values if the number is less than 16, between 16 and 64, and greater than 64. Here's what I've been trying to do:

=IF(BU2<16,BV2,IF(16<BU2<64,BW2,IF(64<BU2,BX2,"")))

The result always just pulls the value of BX2, no matter what the value in BU2 is.

I know it's something very basic. I've done nested IF functions before and I don't know what I'm doing wrong here. I'm sure I'm just very frustrated and missing some small detail. I'd be very grateful if someone could end this nightmare for me. Thanks!