| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
On Sun, 29 May 2005 14:29:51 -0700, Lee wrote:
How would I write a function with the following conditions If H1 < 1.7 and K2 <=1 return 1 If H1 < 1.7 and K2 is between 1 and 2 return 2 (if k2 = 2 return 2) If H1 < 1.7 and K2 is between 2 and 3 return 3 (if k2 = 2 return 3) If H1 < 1.7 and K2 3 return 3 If H1 = 1.7 return 1.7 =IF(H1<1.7,MAX(1,MIN(3,CEILING(K2,1))),1.7) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Format Question Please | Excel Discussion (Misc queries) | |||
| COUNTIF Question | Excel Worksheet Functions | |||
Threaded Mode
