Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
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 "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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
And exactly what is in J57:J59 on Worksheet 2?
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
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. "Shane Devenshire" wrote: 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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
J57: =SUM(C21,C31,C38,C44,C52,C62,H17,H29,H36,H42,H48,H 55)
J59: =J57*15% "Glenn" wrote: And exactly what is in J57:J59 on Worksheet 2? 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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
Amateur wrote:
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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
FANTASTIC. THAT'S IT.
Thanks very much. I really appreciate the time you spent figuring it out. "Glenn" wrote: Amateur wrote: 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. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas between worksheets
Thanks so much for spotting my mistake. I really appreciate it.
"xlmate" wrote: 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 "Amateur" wrote: 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. "Shane Devenshire" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas between worksheets | New Users to Excel | |||
formulas for multiple worksheets | Excel Worksheet Functions | |||
Formulas Across Worksheets | Excel Discussion (Misc queries) | |||
formulas and worksheets | Excel Discussion (Misc queries) | |||
Formulas in Worksheets | Excel Discussion (Misc queries) |