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


"Jane" wrote:

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.
--
thank you