|
IF AND question corrected
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 |
Try this:
=IF(or(H1=1.7,k2<1),1.7,IF(K2<=1,1,IF(K2<=2,2,3)) ) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lee" wrote in message ... 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 |
Correction, try this:
=IF(OR(H1=1.7,K2<1),1.7,IF(K2=1,1,IF(K2<=2,2,3))) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Try this: =IF(or(H1=1.7,k2<1),1.7,IF(K2<=1,1,IF(K2<=2,2,3)) ) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Lee" wrote in message ... 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 |
On Sun, 29 May 2005 14:30:46 -0700, Lee wrote:
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 =IF(OR(H1=1.7,AND(H1<1.7,K2<1)),1.7,MIN(3,CEILING (K2,1))) --ron |
| All times are GMT +1. The time now is 01:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com