CELL Function: cell reference by formula

G

Guest

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?
 

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

Prevent function errors caused by cutting & paste or drag & drop 1
Using a formula to select a cell using the row and column values 7
evaluate a concatenate expression 3
use of ADDRESS function within CELL function 4
how do I create a cell reference from ADDRESS function return? 3
Transfer cell values to another cell by selecting button. 2
using the Cell function 2
Copy Excel functions formula and auto refresh refresh 3

Top