CELL Function: cell reference by formula
 

I want to use the CELL function to obtain the value of 'the cell transpose'.
To take an example in cell B3 I had the formula:-
=IF(CELL("contents",C2)=1,0,1) which looks at the contents of cell C2 and
puts in B3 the 'opposite' of cell C2 contents. To get the correct results
over one half of a matrix, you can not drag the formula, so I substituted the
cell reference as below.

=IF(CELL("contents",CHAR(64+ROW())&COLUMN())=1,0,1 )

This works on its own, but not in the CELL function. It just returns an
error on trying to leave the cell. How do I get it to work?

CELL Function: cell reference by formula
 

Maybe this........

=IF(CELL("contents",$C2)=1,0,1)


Vaya con Dios,
Chuck, CABGx3


"Alex C" wrote:

I want to use the CELL function to obtain the value of 'the cell transpose'.
To take an example in cell B3 I had the formula:-
=IF(CELL("contents",C2)=1,0,1) which looks at the contents of cell C2 and
puts in B3 the 'opposite' of cell C2 contents. To get the correct results
over one half of a matrix, you can not drag the formula, so I substituted the
cell reference as below.

=IF(CELL("contents",CHAR(64+ROW())&COLUMN())=1,0,1 )

This works on its own, but not in the CELL function. It just returns an
error on trying to leave the cell. How do I get it to work?