Formulas between worksheets
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?
|