Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding formula won't copy to other cells in column - why?
I have a formula in cell G2 that reads: =round(F2,0). I'm using this to
round the value in cell F2 and remove decimal places. The entire "F" column has values I want to round, and I am unable to "fill" the formula so that I can get the rounded values of each record in the range. What should I be looking for? |
#2
|
|||
|
|||
So what *does* happen when you copy the formula in G2 to other cells in
the column? Check to make sure Calculation is set to Automatic (Tools/Options/Calculation). In article , LindaO wrote: I have a formula in cell G2 that reads: =round(F2,0). I'm using this to round the value in cell F2 and remove decimal places. The entire "F" column has values I want to round, and I am unable to "fill" the formula so that I can get the rounded values of each record in the range. What should I be looking for? |
#3
|
|||
|
|||
When I try to copy the formula down to other cells in the column, the answer
to the first cell shows in all other cells, even though the formula has changed relative to the location of the copy (F2 becomes F3, etc.). I don't even get the option to "fill" the range if I use the right mouse on the cell selector corner. Seems strange... "JE McGimpsey" wrote: So what *does* happen when you copy the formula in G2 to other cells in the column? Check to make sure Calculation is set to Automatic (Tools/Options/Calculation). In article , LindaO wrote: I have a formula in cell G2 that reads: =round(F2,0). I'm using this to round the value in cell F2 and remove decimal places. The entire "F" column has values I want to round, and I am unable to "fill" the formula so that I can get the rounded values of each record in the range. What should I be looking for? |
#4
|
|||
|
|||
So did you check to see that Calculation was Automatic?
In article , LindaO wrote: When I try to copy the formula down to other cells in the column, the answer to the first cell shows in all other cells, even though the formula has changed relative to the location of the copy (F2 becomes F3, etc.). I don't even get the option to "fill" the range if I use the right mouse on the cell selector corner. Seems strange... "JE McGimpsey" wrote: So what *does* happen when you copy the formula in G2 to other cells in the column? Check to make sure Calculation is set to Automatic (Tools/Options/Calculation). |
#5
|
|||
|
|||
Wow! Do I feel Stupid! You are correct - the radio button for Automatic had
been deselected. When I selected Automatic - just like a miracle - my numbers appeared! Thanks! "JE McGimpsey" wrote: So did you check to see that Calculation was Automatic? In article , LindaO wrote: When I try to copy the formula down to other cells in the column, the answer to the first cell shows in all other cells, even though the formula has changed relative to the location of the copy (F2 becomes F3, etc.). I don't even get the option to "fill" the range if I use the right mouse on the cell selector corner. Seems strange... "JE McGimpsey" wrote: So what *does* happen when you copy the formula in G2 to other cells in the column? Check to make sure Calculation is set to Automatic (Tools/Options/Calculation). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
copy formula and get value instead | Excel Discussion (Misc queries) | |||
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Cells displays formula, not results | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |