=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!

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

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History