Greater than or equal to

[Sroule]

Two columns

column 1: Depth
Column 2: Box Width

I need a formula for the box width column that says.....if the number in the depth column is greater than 4 but less than 6 it equals 4....If the number is greater than 6 but less than 20 it equals 8

 

[Fluff]

What should happen if the depth is less than 4 or greater than 20?

 

[Sroule]

Two columns

column 1: Depth
Column 2: Box Width

I need a formula for the box width column that says.....if the number in the depth column is greater than 4 but less than 6 it equals 4....If the number is greater than 6 but less than 20 it equals

What should happen if the depth is less than 4 or greater than 20?

less than 4 it would equal 0
greater than 20 it would still equal 8

 

[Fluff]

Ok, how about

=IF(A2<4,0,IF(A2<6,4,8))

 

[Sroule]

Ok, how about

=IF(A2<4,0,IF(A2<6,4,8))

with the same scenario could you create another formula that has it where if it is less than 4 than it would equal that number EX; 3.7 would equal 3.7, but 4.1 = 4 still!

 

[Fluff]

Just replace the 0 with A2