Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Dragging Formulas
Hi there
I have suddenly had this problem appear in my work book and do not know why it has started to do this. When I drag down a formula in a cell, the row number changes in the formula, however the actual value within the cell stays the same as the original cell that I've dragged down from. For example. Cell D2 has a value of £11.95, and D3 has a value of £12.95. I want to show these prices excluding VAT, therefore in the next column (E2) I have the formula =SUM(D2/1.175) which gives a value of £10.17. I then drag the formula down from E2 onto E3. The formula states correctly =SUM(D3/1.175), however the vlaue is still £10.17 and not £11.02 which would be the correct value. If I manually type the formula the correct answer appears, but as I have rows of prices I need the drag feature to work correctly again. Please can anyone help me on this. Thanks Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Dragging Formulas
Hi
Press F9 and see if that helps. Maybe your calculation is on manual (See Tools, Option, tab Calculation); switch it to Automatic. regards, Hans -----Original Message----- Hi there I have suddenly had this problem appear in my work book and do not know why it has started to do this. When I drag down a formula in a cell, the row number changes in the formula, however the actual value within the cell stays the same as the original cell that I've dragged down from. For example. Cell D2 has a value of £11.95, and D3 has a value of £12.95. I want to show these prices excluding VAT, therefore in the next column (E2) I have the formula =SUM(D2/1.175) which gives a value of £10.17. I then drag the formula down from E2 onto E3. The formula states correctly =SUM(D3/1.175), however the vlaue is still £10.17 and not £11.02 which would be the correct value. If I manually type the formula the correct answer appears, but as I have rows of prices I need the drag feature to work correctly again. Please can anyone help me on this. Thanks Phil . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Dragging Formulas
Hi
Maybe: Tools, Options, Calculation and set to "Automatic" HTH Cordially Pascal "Music Non Stop" a écrit dans le message de ... Hi there I have suddenly had this problem appear in my work book and do not know why it has started to do this. When I drag down a formula in a cell, the row number changes in the formula, however the actual value within the cell stays the same as the original cell that I've dragged down from. For example. Cell D2 has a value of £11.95, and D3 has a value of £12.95. I want to show these prices excluding VAT, therefore in the next column (E2) I have the formula =SUM(D2/1.175) which gives a value of £10.17. I then drag the formula down from E2 onto E3. The formula states correctly =SUM(D3/1.175), however the vlaue is still £10.17 and not £11.02 which would be the correct value. If I manually type the formula the correct answer appears, but as I have rows of prices I need the drag feature to work correctly again. Please can anyone help me on this. Thanks Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dragging formulas | Excel Discussion (Misc queries) | |||
Problem dragging formulas | Excel Discussion (Misc queries) | |||
Dragging Formulas | Excel Discussion (Misc queries) | |||
dragging formulas | Excel Discussion (Misc queries) | |||
Dragging formulas | Excel Worksheet Functions |