AND IF formula

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

I need a formula that if three conditions are met then the word "yes" is
entered. Have tried =IF(AND(J2<K2,L2>.08,L2<.098),"yes",''") and this
doesn't work.
 
EXCEL 2007

Try this:-

=(IF(AND(J2<K2,L2>0.08,L2<0.98),"yes","no"))

The above works for me though have not tested it extensively.

If my comments have helped please hit Yes.

Thanks.
 
Jane,

Try this

=IF(AND(J2<K2,L2>0.08,L2<0.098),"yes","")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Sorry my .98 should read .098.


trip_to_tokyo said:
EXCEL 2007

Try this:-

=(IF(AND(J2<K2,L2>0.08,L2<0.98),"yes","no"))

The above works for me though have not tested it extensively.

If my comments have helped please hit Yes.

Thanks.
Click to expand...
 
You miss typed the "".
Don't type single quotes.
Hold the shift key while typing the Quotes [like before & after the "yes"].
Micky
 
Back
Top