How to create a formala in one sheet for a cell in another sheet?
 

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

How to create a formala in one sheet for a cell in another sheet?
 

=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