Hi,

Well it doen't look like anything wrong with the formula so

1. check to make sure calculation is set to Automatic - Tools, Options,
Calculation, Manual.
2. Check to make sure that the format if J60 (and) the cell with your
=Savings!J60*2 are not set to Text. You can enter a formula like
=ISTEXT(J60) and see if it returns TRUE, if so that is your problem.
3. You didn't tell us what the value in J60 was. For example if it's small
and you have the format on Sheet1 set to say $0.0 you might not see a result
due to display rounding.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Amateur" wrote:

Worksheet 2 (budget): =SUM(J57:J59)

The problem cell on worksheet 1 (savings) reads: =Savings!J60*2

Clear as mud to me.

"Shane Devenshire" wrote:

Hi,

Show us the formula.

What is the content of the cell on sheet2?

Check your formatting.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Amateur" wrote:

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?