Home |
Search |
Today's Posts |
#1
|
|||
|
|||
fill handle + query
I can't seem to get the fill handle "+" sign to give the correct amounts when
I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#2
|
|||
|
|||
Vickie: What's the formula you're copying?
************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#3
|
|||
|
|||
I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill
handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#4
|
|||
|
|||
Do you have calculation on manual? (Tools--Options, Calculation tab). I
can't imagine what else it could be. ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#5
|
|||
|
|||
No I don't I have on "automatic". I have just installed 2003 and I used to
have the same problem on 2000 as well. Thought going to 2003 was going to improve the problem. Thanks for your help. Also looked at your website very imformative. "Anne Troy" wrote: Do you have calculation on manual? (Tools--Options, Calculation tab). I can't imagine what else it could be. ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#6
|
|||
|
|||
Thanks, Vickie. Is this only one particular workbook? I cannot imagine what
else the problem could be. Can you give an example of the data and the answers you're getting? And could you try the formula on a row, and change the values it's working on (i.e., is Excel seeing the data as numbers?)? Hope this makes sense. ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... No I don't I have on "automatic". I have just installed 2003 and I used to have the same problem on 2000 as well. Thought going to 2003 was going to improve the problem. Thanks for your help. Also looked at your website very imformative. "Anne Troy" wrote: Do you have calculation on manual? (Tools--Options, Calculation tab). I can't imagine what else it could be. ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance |
#7
|
|||
|
|||
If you turn calculation to automatic, does it work ok?
Vickie wrote: No I don't I have on "automatic". I have just installed 2003 and I used to have the same problem on 2000 as well. Thought going to 2003 was going to improve the problem. Thanks for your help. Also looked at your website very imformative. "Anne Troy" wrote: Do you have calculation on manual? (Tools--Options, Calculation tab). I can't imagine what else it could be. ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance -- Dave Peterson |
#8
|
|||
|
|||
Do you want every row to multiply by the value in cell B1? If so, use an
absolute reference, e.g.: =A3*$B$1 If that's not the problem, select one of the cells that's showing an incorrect result. Click in the formula bar, and see which cells on the worksheet are outlined with colour. Is there a value in each of those cells? Vickie wrote: I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#9
|
|||
|
|||
Thank you Debra, Ann and Dave for all trying to fix my problem. Debra gets
the 1st prize!!! woo hoo thank you so much I have been asking people for days to get this fixed. I think the only difference in your formula to everyone else that has tried to help me outside of the forum and my friends is the the extra $ in front of the last digit. i.e I have done $ in front of B but never in front of 1. And it worked! What a relief. Bless you! Vickie "Debra Dalgleish" wrote: Do you want every row to multiply by the value in cell B1? If so, use an absolute reference, e.g.: =A3*$B$1 If that's not the problem, select one of the cells that's showing an incorrect result. Click in the formula bar, and see which cells on the worksheet are outlined with colour. Is there a value in each of those cells? Vickie wrote: I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#10
|
|||
|
|||
You're welcome! Thanks for letting me know that it worked.
You can use a $ sign in front of the column letter and/or the row number in a cell reference. It locks that part of the reference, and prevents it from changing if you copy the formula to another cell. Vickie wrote: Thank you Debra, Ann and Dave for all trying to fix my problem. Debra gets the 1st prize!!! woo hoo thank you so much I have been asking people for days to get this fixed. I think the only difference in your formula to everyone else that has tried to help me outside of the forum and my friends is the the extra $ in front of the last digit. i.e I have done $ in front of B but never in front of 1. And it worked! What a relief. Bless you! Vickie "Debra Dalgleish" wrote: Do you want every row to multiply by the value in cell B1? If so, use an absolute reference, e.g.: =A3*$B$1 If that's not the problem, select one of the cells that's showing an incorrect result. Click in the formula bar, and see which cells on the worksheet are outlined with colour. Is there a value in each of those cells? Vickie wrote: I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill handle bottom down each of the columns down about 20 rows or so and it doesn't give me the correct amounts. "Anne Troy" wrote: Vickie: What's the formula you're copying? ************ Anne Troy www.OfficeArticles.com "Vickie" wrote in message ... I can't seem to get the fill handle "+" sign to give the correct amounts when I want to copy a formula down a column. It seems to skip every 2nd row with the wrong amount or sometimes it will give a 0.00 sign. Any suggestions. Thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill handle formula | Excel Worksheet Functions | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) | |||
Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |