LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
becky
 
Posts: n/a
Default LOTUS 123 TO EXCEL 2003

I work for a company that is converting all of their Lotus 123 (Dos Version
Release 2.2) spreadsheets to Excel.

I do not understand this Lotus formula =AND(A9=$AA$2,A9<=$AB$2) in cell
AC2.

The "A" column is full of dates.
AA2 has another date January 1, 2005, and AB2 has another date January 31,
2005.

A9 is a dashed line no date or pertinent information. When I can the
formula to A10 which is the first cell with a date the AC2 cell now says true
or false.

I want the formula to look at the whole column and determine which dates are
in between 01-01-05 and 01-31-05. Can someone help me write this formula.

--
bb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
Still Convert Lotus 123 to Excel 2003 becky Excel Discussion (Misc queries) 2 December 24th 04 02:14 AM


All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"