| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula does not calculate - Have tried F9
I have a very simple problem that is frustrating me...
I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
I'd select a single cell (so that all cells are changed)
then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
Excel didn't like that (I'm using Excel 2000) - also Excel has stopped
working - not enough memory! Any other ideas? "Dave Peterson" wrote: I'd select a single cell (so that all cells are changed) then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
Choose smaller ranges (do them one at a time) and do the edit|replace stuff.
Anisette wrote: Excel didn't like that (I'm using Excel 2000) - also Excel has stopped working - not enough memory! Any other ideas? "Dave Peterson" wrote: I'd select a single cell (so that all cells are changed) then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
Why the suggestion to edit the formulas when OP stated
only works when I go in to each cell in my column of numbers and hit return I interpreted this to mean the numbers were bogus so posted the "change text nums to real nums fix" Gord .. On Wed, 26 Jul 2006 14:42:30 -0500, Dave Peterson wrote: Choose smaller ranges (do them one at a time) and do the edit|replace stuff. Anisette wrote: Excel didn't like that (I'm using Excel 2000) - also Excel has stopped working - not enough memory! Any other ideas? "Dave Peterson" wrote: I'd select a single cell (so that all cells are changed) then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
On the other hand..............if the numbers were bogus, what would trigger the
formulas to work by selecting a number and hitting Enter? So maybe OP is not hitting Enter on the numbers column, but on the formulas column. I have confused myself thoroughly so I will have some lunch and go play 18 holes. Gord On Wed, 26 Jul 2006 13:32:31 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Why the suggestion to edit the formulas when OP stated only works when I go in to each cell in my column of numbers and hit return I interpreted this to mean the numbers were bogus so posted the "change text nums to real nums fix" Gord . On Wed, 26 Jul 2006 14:42:30 -0500, Dave Peterson wrote: Choose smaller ranges (do them one at a time) and do the edit|replace stuff. Anisette wrote: Excel didn't like that (I'm using Excel 2000) - also Excel has stopped working - not enough memory! Any other ideas? "Dave Peterson" wrote: I'd select a single cell (so that all cells are changed) then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson Gord Dibben MS Excel MVP |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
I thought that the problem was that the formula returned a value--just not the
correct value (it wasn't displaying just the formula). And by changing = to =, excel will see that as a change to the formula and reevaluate those cells. (And by limiting the range to something smaller, xl might not hang.) Gord Dibben wrote: Why the suggestion to edit the formulas when OP stated only works when I go in to each cell in my column of numbers and hit return I interpreted this to mean the numbers were bogus so posted the "change text nums to real nums fix" Gord . On Wed, 26 Jul 2006 14:42:30 -0500, Dave Peterson wrote: Choose smaller ranges (do them one at a time) and do the edit|replace stuff. Anisette wrote: Excel didn't like that (I'm using Excel 2000) - also Excel has stopped working - not enough memory! Any other ideas? "Dave Peterson" wrote: I'd select a single cell (so that all cells are changed) then Edit|replace what: = (equal sign) with: = (equal sign) replace all Maybe it'll wake xl up! Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula does not calculate - Have tried F9
Could be the numbers are text.
Re-formatting alone will not change them to real numbers. Format all to General. Copy an empty cell. Select the column of numbers and Paste SpecialAddOKEsc. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 10:55:02 -0700, Anisette wrote: I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to the side I have a series of IF functions, each one comparing the value of each cell of numbers with a defined limit. The IF function only works when I go in to each cell in my column of numbers and hit return. I have more than 5000 entries, so I am desperate to find a way of getting the IF function to recognise the numbers and give a result without having to hit Enter on every number. I have checked Tools/Options/Calculation and Automatic is ticked. I have set it to manual, and then set it back to Automatic just to be sure. I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Formula to calculate over-time | Excel Discussion (Misc queries) | |||
Hybrid Mode
