Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AND IF formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AND IF formula
EXCEL 2007
Try this:- =(IF(AND(J2<K2,L20.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" 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AND IF formula
Jane,
Try this =IF(AND(J2<K2,L20.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. "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
AND IF formula
Sorry my .98 should read .098.
"trip_to_tokyo" wrote: EXCEL 2007 Try this:- =(IF(AND(J2<K2,L20.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" 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
AND IF formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|