123 to Excel Conversion DATATYPE???

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
 
D

Dave

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
 
Top