Entering a number based on it's position in a range

[Scott Krause]

I'm trying to enter data based on it's position in a range of numbers.

I'm creating a weight lifting program for our HS and need to put a certain number into a cell based on another cell, in this case R4. So here's what I'm trying to get accomplished with IF's below. If R4 is less than 135, enter 30. If R4 is greater than 135 but less than 225, enter 45. If R4 is greater than 225 but less than 315, enter 60. If R4 is greater than 315, enter 75.




=IF(R4<135,30, IF(135<R4<225,45, IF(225<R4<315,75,60)))

Thanks,

Scott Krause

 

[Scott Krause]

Sorry, here's the full formula I used....



=IF(R4<135,30, IF(135

<R4< p><225,45,
IF(225
<R4<315,75,60)))<R4<315,75,60)))<R4<225,45, p IF(225<R4<315,75,60)))< IF(225<R4<315,75,60)))<R4<225,45,>

 

[BAlGaInTl]

I'm trying to enter data based on it's position in a range of numbers.

I'm creating a weight lifting program for our HS and need to put a certain number into a cell based on another cell, in this case R4. So here's what I'm trying to get accomplished with IF's below. If R4 is less than 135, enter 30. If R4 is greater than 135 but less than 225, enter 45. If R4 is greater than 225 but less than 315, enter 60. If R4 is greater than 315, enter 75.



=IF(R4<135,30, IF(135<R4<225,45, IF(225<R4<315,60,75)))
Thanks,

Scott Krause

If statements execute in order... so as long as you go from low to high, this should work

=IF(R4<135,30, IF(R4<225,45, IF(R4<315,60,75)))

 

[Scott Krause]

Sorry, again, I can't seem to get this entire formula to show up.

=IF
(R4
<135
,30
, IF
(135
<R4
<225,
45,
IF(225
<R4
<315,
75,60)))

 

[BAlGaInTl]

The formula was all there...

The forum gets confused and truncates formulas some of the time when they contain < or >.

I simply quoted your original post to see what the formula you typed in was.

 

[Scott Krause]

That's it! Thanks!