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

B

Beth

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
 
P

Peo Sjoblom

=IF(Sheet2!A1>0,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
 
Top