Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |