IF AND question corrected

L

Lee

How would I write a function with the following conditions

If H1 < 1.7 and K2 <1 return 1.7
If H1 < 1.7 and K2 is between 1 and 2 return 2 (if k2 = 1 return 1, if k2 =
2 return 2)
If H1 < 1.7 and K2 is between 2 and 3 return 3 (if k2 = 3 return 3)
If H1 < 1.7 and K2 > 3 return 3
If H1 >= 1.7 return 1.7

Sorry for the errors in my previous post

Lee
 
R

Ron Rosenfeld

How would I write a function with the following conditions

If H1 < 1.7 and K2 <1 return 1.7
If H1 < 1.7 and K2 is between 1 and 2 return 2 (if k2 = 1 return 1, if k2 =
2 return 2)
If H1 < 1.7 and K2 is between 2 and 3 return 3 (if k2 = 3 return 3)
If H1 < 1.7 and K2 > 3 return 3
If H1 >= 1.7 return 1.7

Sorry for the errors in my previous post

Lee
Click to expand...


=IF(OR(H1>=1.7,AND(H1<1.7,K2<1)),1.7,MIN(3,CEILING(K2,1)))
--ron
 
Top