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

IF AND with value between a range
 

Try this:

=IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","")

--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
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

IF AND with value between a range
 

=IF(AND(B1J679,A1=1.65,A1<=1.99),"not okay","")

"Jane" wrote:

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

IF AND with value between a range
 

ah of course!

I made it much harder than it needed to be.

thank you!

"T. Valko" wrote:

Try this:

=IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","")

--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
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

IF AND with value between a range
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
ah of course!

I made it much harder than it needed to be.

thank you!

"T. Valko" wrote:

Try this:

=IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","")

--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
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