"Grant Reid" wrote in message
...
I want to able to combine the functionality of these two formulas but do
not
seem to able to make any headway. My logic was as follows;
=CELL("type",ADDRESS(ROW(),1))

=IF(ISBLANK(INDIRECT(ADDRESS(ROW(),1))),0,1)

HTH,
Andy