This statement returns a false

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 •


#1
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 •
Related Solutions


Ask Question