#### Scott Krause

##### Board Regular

- Joined
- Mar 8, 2009

- Messages
- 96

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

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

Last edited: