In a cell of worksheet 1 I type =; then go to worksheet 2, click on a cell;
go back to worksheet 1 formula bar and add *2 then tab. I'm getting 0 which
is wrong.

The cell in worksheet 2 has a formula adding a couple of other cells. Is
that causing the problem?

I don't know what I've done wrong. Can anyone help?