This statement returns a false

Tags:

ALLEN April 20, 2012 at 15:27:57
Specs: Windows 7

THIS STATEMENTS RETURNS A FALSE =IF(C412="mem",IF(AND(EJ412>Sheet1!$E$19,EJ412<Sheet1!$F$19),"PM",IF(AND(EJ412>Sheet1!$E$20,EJ412<Sheet1!$F$20),"PM",0)))

See More: This statement returns a false

Report •

mmcconaghy April 21, 2012 at 07:19:45

OK, had my morning coffee, try this:

=IF(C412="mem",IF(AND(EJ412>Sheet1!$E$19,EJ412<Sheet1!$F$19),"PM",IF(AND(EJ412>Sheet1!$E$20,EJ412<Sheet1!$F$20),"PM",0)),"")
MIKE
http://www.skeptic.com/

Report •

Start a discussion

Related Solutions

› Need help with IF CELL = RANGE ,TRUE,FALSE
› [Solved] If AND Statement to Check in two Columns
› How to use an Today() statement in an IF() statement in Exce
› [Solved] Nested if returning false
› Vlookup returns same value for all rows
› Excel Nested If Statement
› Delete false e-mail addresses

See More ↓

Ask Your Question

Weekly Poll

Do you think Google's new music streaming service will change how people purchase music?

Poll Finishes In 2 Days.
Discuss in The Lounge
Poll History