View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jane Jane is offline
external usenet poster
 
Posts: 202
Default IF AND with value between a range

If need help on a formula that will return "not okay"for the following
condition:

If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay",
otherwise ""

col A col B cellJ679 = 12
row 1 1.42 7
row 2 1.68 15
row 3 1.80 12
row 4 2.0 24

thank you in advance! jane