123 to Excel Conversion DATATYPE???

  • Thread starter Thread starter A McMillan
  • Start date Start date
A

A McMillan

Dear all,

I am currently converting a 123 to Excel spreadsheet, the following is
the conversion into Excel, however I am now stuck!

=IF(AND(CELL("DATATYPE",$B$12)<>"b",$B$12="Y"),1,0)

What is DATATYPE and what is the equivalent Excel?

Many Thanks for your help

A McMillan
 
I had something similar when converting Lotus to Excel. I believe what you
are looking for is the Cell worksheet formula:
CELL(info_type,reference) - see Help for more info.



dave
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing data. Problem with datatype in column 2
Graphic but referencing the values range for Y axis in an externalcell (indirect reference) 1
Formula and Formating Help 5
Copying rows of data into new worksheet but placing data into colu 1
conversion of lotus 123 files to excel 2
EXCEL read a text string as scientific notation 7
Convincing 123 users to convert to Excel 2
Converting a Lotus 123 file to Excel 2

Back
Top