Formulas between worksheets

[Amateur]

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?

 

[Shane Devenshire]

Hi,

Show us the formula.

What is the content of the cell on sheet2?

Check your formatting.

 

[Amateur]

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

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

Clear as mud to me.

 

[xlmate]

the cell on your sheet 1 should read as Budget!J60*2

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis
(e-mail address removed)

 

[Glenn]

And exactly what is in J57:J59 on Worksheet 2?

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

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

Clear as mud to me.

 

[Shane Devenshire]

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.

 

[Amateur]

Thanks for your suggestions. I've done all the checks you suggested. No
problems. Just want to check you meant automatic rather than manual should
be selected from the calculation option.

xlmate: I agree, I would have expected the formula to read =Budget!J60*2.
When I click on the cell in the budget worksheet it reads =Budget!J60 but as
soon as I select the savings worksheet it changes to =Savings!J60

Still a mystery.

 

[Amateur]

J57: =SUM(C21,C31,C38,C44,C52,C62,H17,H29,H36,H42,H48,H55)
J59: =J57*15%

 

[Glenn]

xlmate: I agree, I would have expected the formula to read =Budget!J60*2.
When I click on the cell in the budget worksheet it reads =Budget!J60 but as
soon as I select the savings worksheet it changes to =Savings!J60

Still a mystery.

After clicking on J60, just type "*2" and hit enter. DO NOT reselect the other
worksheet.

 

[Amateur]

FANTASTIC. THAT'S IT.

Thanks very much. I really appreciate the time you spent figuring it out.

 

[xlmate]

you have bring your focus back to the Savings sheet and that why
the formula shows =Savings!J60

you just need to press enter after linking in the Budget sheet
and it will show =Budget!J60, then click F2 and type
*2 on the formula bar

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis
(e-mail address removed)

 

[Amateur]

Thanks so much for spotting my mistake. I really appreciate it.