IF AND question
 

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

Your second and third line cannot work.

See if this fits your scenario:

=IF(H1=1.7,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
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

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