Using IF & AND and getting #NAME?
"T. Valko" wrote:
For cryin out loud!
2 more typos:
=IF(AND(AE1=DATE(2005,7,1),AE<=DATE(2006,6,30))," FY2005","NA")
=IF(AND(AE1=DATE(2005,7,1),AE1<=DATE(2006,6,30)), "FY2005","NA")
=IF(AND(AE1=A1,AE<=B1),"FY2005","NA")
=IF(AND(AE1=A1,AE1<=B1),"FY2005","NA")
--
Biff
Microsoft Excel MVP
Got it. :-)
|