=IF(Sheet2!A10,1,0)

as an example, easiest way is actually to use the mouse and select the
cell(s) on the other sheet, that way sheet names will be inserted
automatically


--

Regards,

Peo Sjoblom


"Beth" wrote in message
...
I need to set up a formula in one sheet to appertain to a cell in another
sheet of the same workbook. is this possible if so how?

Ant help would be great thanks