Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
I'm using Excel 2007.
I have been using a spreadsheet for a basic accounting project and had the following basic formula: =5x+5y When I use the pull down function to copy this formula down several rows, it gives me the proper formula (i.e. =6x+6y, =7x+7y), but the answer is just a copy of the answer from the original formula. I have clicked the little table and it only gives me three options: copy cell, format only, fill without formatting. The spreadhseet that i am using has worked for over 4 years, and now it no longer works. I cant get this to work in any spreadsheet now and have even removed and then reinstalled office. It's probably something dumb I did, but I am stuck. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
it gives me the proper formula, but the answer is just a
copy of the answer from the original formula Sounds like calc is set to manual. Try pressing F9 to recalc. Does it compute properly now? In xl03, click ToolsOptionsCalculation tab to re-set calc mode to Auto. Maybe you could try equiv. steps in your xl07. -- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
In Excel 07 the steps a
Click the Office Beach Ball Click Excel Options button (at bottom) Select Formulas (on left) And under the word Calculation make sure it is set to Automatic Choose OK On Sep 20, 7:07*pm, bryanchughes wrote: I'm using Excel 2007. I have been using a spreadsheet for a basic accounting project and had the following basic formula: =5x+5y When I use the pull down function to copy this formula down several rows, it gives me the proper formula (i.e. =6x+6y, =7x+7y), but the answer is just a copy of the answer from the original formula. I have clicked the little table and it only gives me three options: copy cell, format only, fill without formatting. The spreadhseet that i am using has worked for over 4 years, and now it no longer works. I cant get this to work in any spreadsheet now and have even removed and then reinstalled office. It's probably something dumb I did, but I am stuck. Please help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
=5x+5y doesn't sound like a formula. If those are supposed to be cell
references, perhaps you intended to say =X5+Y5 ? If you are trying to multiply variables which you had named x and y, the perhaps you intended to say =5*x+5*y ? -- David Biddulph "Reitanos" wrote in message ... In Excel 07 the steps a Click the Office Beach Ball Click Excel Options button (at bottom) Select Formulas (on left) And under the word Calculation make sure it is set to Automatic Choose OK On Sep 20, 7:07 pm, bryanchughes wrote: I'm using Excel 2007. I have been using a spreadsheet for a basic accounting project and had the following basic formula: =5x+5y When I use the pull down function to copy this formula down several rows, it gives me the proper formula (i.e. =6x+6y, =7x+7y), but the answer is just a copy of the answer from the original formula. I have clicked the little table and it only gives me three options: copy cell, format only, fill without formatting. The spreadhseet that i am using has worked for over 4 years, and now it no longer works. I cant get this to work in any spreadsheet now and have even removed and then reinstalled office. It's probably something dumb I did, but I am stuck. Please help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
This advice and the advice given by Retanos worked. I actually went to the
formulas tab, and made the switch under the calculation options button. Thanks for the help! "Max" wrote: it gives me the proper formula, but the answer is just a copy of the answer from the original formula Sounds like calc is set to manual. Try pressing F9 to recalc. Does it compute properly now? In xl03, click ToolsOptionsCalculation tab to re-set calc mode to Auto. Maybe you could try equiv. steps in your xl07. -- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula is correct, but result will not show
Welcome, glad it resolved your issue.
-- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- "bryanchughes" wrote in message ... This advice and the advice given by Reitanos worked. I actually went to the formulas tab, and made the switch under the calculation options button. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#value! on spreadsheet when formula palette gets correct result | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
Function WEEKNUM does not show correct result for 15.2.2005 | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions |