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
|
|||
|
|||
Fun With That Wages Book Again
G H
450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#2
|
|||
|
|||
Fun With That Wages Book Again
ToolsOptionsCalculation.
Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#3
|
|||
|
|||
Fun With That Wages Book Again
Thanks for answering Gord.
Automatic is ticked and this still is happening. It seems to be only when I'm doing accumulating that this problem arises. Any other ideas on how to solve it? I'd appreciate it. Gatsby "Gord Dibben" wrote: ToolsOptionsCalculation. Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#4
|
|||
|
|||
Fun With That Wages Book Again
Change your formula to read =IF(G12="","",H11+G12), and drag all the way
down. This way, H will remain blank until G gets a value. In your scenario, H12 will show a value, but H13 will remain blank until you enter a value in G13 -- Hth Kassie Kasselman "Gatsby" wrote: Thanks for answering Gord. Automatic is ticked and this still is happening. It seems to be only when I'm doing accumulating that this problem arises. Any other ideas on how to solve it? I'd appreciate it. Gatsby "Gord Dibben" wrote: ToolsOptionsCalculation. Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#5
|
|||
|
|||
Fun With That Wages Book Again
Kassie, that's working! Thanks very much for helping me. I've spent hours
trying to get around it, wondering what was wrong? Have you any idea why 'my way' doesn't work? Thanks again. Gatsby "kassie" wrote: Change your formula to read =IF(G12="","",H11+G12), and drag all the way down. This way, H will remain blank until G gets a value. In your scenario, H12 will show a value, but H13 will remain blank until you enter a value in G13 -- Hth Kassie Kasselman "Gatsby" wrote: Thanks for answering Gord. Automatic is ticked and this still is happening. It seems to be only when I'm doing accumulating that this problem arises. Any other ideas on how to solve it? I'd appreciate it. Gatsby "Gord Dibben" wrote: ToolsOptionsCalculation. Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#6
|
|||
|
|||
Fun With That Wages Book Again
That's a pleasure Gatsby! 'Your way' doen't work because something plus
nothing is still something! -- Hth Kassie Kasselman "Gatsby" wrote: Kassie, that's working! Thanks very much for helping me. I've spent hours trying to get around it, wondering what was wrong? Have you any idea why 'my way' doesn't work? Thanks again. Gatsby "kassie" wrote: Change your formula to read =IF(G12="","",H11+G12), and drag all the way down. This way, H will remain blank until G gets a value. In your scenario, H12 will show a value, but H13 will remain blank until you enter a value in G13 -- Hth Kassie Kasselman "Gatsby" wrote: Thanks for answering Gord. Automatic is ticked and this still is happening. It seems to be only when I'm doing accumulating that this problem arises. Any other ideas on how to solve it? I'd appreciate it. Gatsby "Gord Dibben" wrote: ToolsOptionsCalculation. Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#7
|
|||
|
|||
Fun With That Wages Book Again
I see now, Kassie. Thanks again. The formula you gave me has made entering
the wages so much easier. When I looked up Conditional Formatting they seemed to be referring to how to change colours depending on values. They should have written pages especially for ME. (HeHe). Gatsby "Gatsby" wrote: Kassie, that's working! Thanks very much for helping me. I've spent hours trying to get around it, wondering what was wrong? Have you any idea why 'my way' doesn't work? Thanks again. Gatsby "kassie" wrote: Change your formula to read =IF(G12="","",H11+G12), and drag all the way down. This way, H will remain blank until G gets a value. In your scenario, H12 will show a value, but H13 will remain blank until you enter a value in G13 -- Hth Kassie Kasselman "Gatsby" wrote: Thanks for answering Gord. Automatic is ticked and this still is happening. It seems to be only when I'm doing accumulating that this problem arises. Any other ideas on how to solve it? I'd appreciate it. Gatsby "Gord Dibben" wrote: ToolsOptionsCalculation. Set to Automatic. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 18:06:00 -0800, Gatsby wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#8
|
|||
|
|||
Fun With That Wages Book Again
Sorry I missed all the fun, but it sounds like you are cruising now!
-- Y "Gatsby" wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#9
|
|||
|
|||
Fun With That Wages Book Again
Thanks, Yacbo!
I still get stuck. Kassie has been a great help, though. I still have problems in other columns with them being filled in all the way down with 'incorrect' figures until I make an entry. When I make an entry it corrects the figure in the adjacent cell to which it refers but the rest, all the way down should not be there. It drives me mad. It doesn't happen with the Formula Kassie gave me, though (=IF(G9="","",H10+G9). Can I call on you guys again or will I drive you all mad? Gatsby. "Yacbo" wrote: Sorry I missed all the fun, but it sounds like you are cruising now! -- Y "Gatsby" wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
#10
|
|||
|
|||
Fun With That Wages Book Again
To be honest, I'm kind of new to this forum and just learning my way around.
Kassie has apparently been most helpful to you as has Gord. These guys are vastly superior to my humble abilities and perhaps one of them will weigh in and answer your question. For my part, I don't quite understand the current question, but stand willing to help in any way possible. To that end, I have two suggestions: First, do another post being more specific as to what the input and output are and why the formulas are not working. And two, you might submit your post to the category of Excel"Worksheet Functions" in addition to this room. Please don't consider this latter suggestion as diversionary-- I just think you might be depriving yourself of a valuable resource in the folks that regularly help over in the "Worksheet Functions" room in which I have gained many helpful tips. I would like to stress that the people who offer help in all these communities are top notch. I feel guilty that I help so little and gain so much from people like Kassie, Gord, and many others! Thanks to all. -- Y "Gatsby" wrote: Thanks, Yacbo! I still get stuck. Kassie has been a great help, though. I still have problems in other columns with them being filled in all the way down with 'incorrect' figures until I make an entry. When I make an entry it corrects the figure in the adjacent cell to which it refers but the rest, all the way down should not be there. It drives me mad. It doesn't happen with the Formula Kassie gave me, though (=IF(G9="","",H10+G9). Can I call on you guys again or will I drive you all mad? Gatsby. "Yacbo" wrote: Sorry I missed all the fun, but it sounds like you are cruising now! -- Y "Gatsby" wrote: G H 450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
|
Thread Tools | |
Display Modes | |
|
|