| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Historical Excel question statistical capabilities | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| test for date in column question | Excel Worksheet Functions | |||
Linear Mode
