View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amateur Amateur is offline
external usenet poster
 
Posts: 7
Default 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?