Auto enter text if tick box checked

[gibbylinks]

Is it possible to put text in a cell, if a check box is ticked somewhere else
on the spreadsheet ? but leave it blank if nothing is ticked.

Cheers

Paul

 

[Dave O]

Check boxes are linked to another cell (you specified this when you set
up the check box). So if "Checkbox1" is linked to cell A10, cell A10
will show TRUE when Checkbox1 is ticked and FALSE when it is unchecked.
In any other cell you could then write an IF statement along the lines
of
=IF(A10=TRUE,"Your text here","")

 

[Bob Phillips]

If you use a tick in a cell, it is easy. Assume that the cell is A1, to get
a tick, form at as Marlett, and enter a. Then in another cell
=IF(A1="a","some text","")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[gibbylinks]

Thanks

Got it working.

Paul

If you use a tick in a cell, it is easy. Assume that the cell is A1, to get
a tick, form at as Marlett, and enter a. Then in another cell
=IF(A1="a","some text","")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[gibbylinks]

Help Panic...... All went well until we tried to protect the cells. Then it
doesn't work, is there a way around this ??

Using Exel 2000

 

[gibbylinks]

Sorted it, we had locked the cell that held the TRUE/FALSE value. Unlocking
that and hiding it has solved it.