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
That's the problem with the Excel help files! Never know what to look for hey.
Try help by typing in IF Worksheet function. How the heck you are supposed to know that that is what you are looking for, beats me though! Still think the best help available is this forum! -- Hth Kassie Kasselman "Gatsby" wrote: 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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|