IF AND question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)))
 
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
Click to expand...


=IF(H1<1.7,MAX(1,MIN(3,CEILING(K2,1))),1.7)


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND question corrected 3
URGENT HELP - SUM FORMULA 5
Check IF statement please 5
Formula assistance column match sum 3
Need Formula to "Adjust" to New Column Assignment 3
Nested IF not working..... 5
VLOOKUP Range 2
Excel Numbering rows by font color, but skipping blanks 1

Back
Top