I am in the process of converting multiple linked Lotus 123 R5 spreadsheets into Excel 2002. After conversion, Excel doesn't like most of the criteria used for for the DBASE function. I've been able to fix some of it, but one problem in particular I am having is with the use of the AND operator in the criteria. For example, in Lotus:
+DATE RECOG<2#AND#+DATE RECOG>-6
means DATE RECOG has to be both less than 2 and greater than -6 to be true.
In Excel, it converts to this:
=AND(DATE_RECOG<2,+DATE_RECOG>-6)
DATE RECOG (not DATE_RECOG) is the column heading in that criteria column. My question is: Is there a way to utilize the AND operator when specifying criteria? I know I could create another DATE RECOG column to store the 2nd value if I wanted to, but then I would have to go around to all the spreadsheets and update the criteria range, which would be highly time consuming. Any suggestions?
Thanks in advance for your help.
Chris
+DATE RECOG<2#AND#+DATE RECOG>-6
means DATE RECOG has to be both less than 2 and greater than -6 to be true.
In Excel, it converts to this:
=AND(DATE_RECOG<2,+DATE_RECOG>-6)
DATE RECOG (not DATE_RECOG) is the column heading in that criteria column. My question is: Is there a way to utilize the AND operator when specifying criteria? I know I could create another DATE RECOG column to store the 2nd value if I wanted to, but then I would have to go around to all the spreadsheets and update the criteria range, which would be highly time consuming. Any suggestions?
Thanks in advance for your help.
Chris