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!
Bookmarks