Thanks
Got it working.
Paul
"Bob Phillips" wrote:
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" wrote in message
...
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
|