Error message on IF(AND) formula

March 13, 2011 at 11:39:29
Specs: Windows 2003
=IF(AND(D20<DATEVALUE("8/01/2006"),E20>=450),"xx","xx",IF(AND(D20=DATEVALUE("08/01/06"):DATEVALUE("10/01/2008")),E20>=100),"xx","yy",IF(AND(D20>=DATEVALUE("10/01/2008"),E20>=110),"xx","yy")

Can anyone help? I know it's probably just a goofy mistake, but I can't see it.
Excel 2003 running on Windows XP OS
Many thanks!


See More: Error message on IF(AND) formula

Report •

#1
March 13, 2011 at 16:45:18
Just from a quick glance, you do not have your IF statements Nested properly:

=IF(
AND(D20<DATEVALUE("8/01/2006"),E20>=450), <-- end of AND
"xx", <-- Value If True
"xx", <-- Value If False & should be end of IF statment !!
IF(
AND(D20=DATEVALUE("08/01/06"):DATEVALUE("10/01/2008")E20>=100), <-- end of AND
"xx", <-- Value If True
"yy", <-- Value If False & should be end of IF statement !!
IF(
AND(D20>=DATEVALUE("10/01/2008"),E20>=110),
"xx",
"yy")

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question