|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2008, 12:07 AM
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
September 21st, 2008, 12:34 AM
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
September 21st, 2008, 01:51 AM
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
September 21st, 2008, 09:32 AM
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
September 21st, 2008, 10:22 PM
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
September 22nd, 2008, 12:02 AM
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
