A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Fun With That Wages Book Again



 
 
Thread Tools Display Modes
  #1  
Old January 7th, 2007, 03:06 AM posted to microsoft.public.excel.setup
Gatsby
external usenet poster
 
Posts: 43
Default 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  
Old January 7th, 2007, 06:09 AM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old January 7th, 2007, 09:56 AM posted to microsoft.public.excel.setup
Gatsby
external usenet poster
 
Posts: 43
Default 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  
Old January 7th, 2007, 10:28 AM posted to microsoft.public.excel.setup
kassie
external usenet poster
 
Posts: 76
Default 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  
Old January 7th, 2007, 10:43 AM posted to microsoft.public.excel.setup
Gatsby
external usenet poster
 
Posts: 43
Default 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  
Old January 7th, 2007, 12:09 PM posted to microsoft.public.excel.setup
kassie
external usenet poster
 
Posts: 76
Default 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  
Old January 7th, 2007, 12:23 PM posted to microsoft.public.excel.setup
Gatsby
external usenet poster
 
Posts: 43
Default 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  
Old January 7th, 2007, 04:27 PM posted to microsoft.public.excel.setup
kassie
external usenet poster
 
Posts: 76
Default 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  
Old January 8th, 2007, 07:17 AM posted to microsoft.public.excel.setup
Yacbo
external usenet poster
 
Posts: 49
Default 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  
Old January 8th, 2007, 03:22 PM posted to microsoft.public.excel.setup
Gatsby
external usenet poster
 
Posts: 43
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.