 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / January 2007Fun 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 Tools>Options>Calculation. Set to Automatic. Gord Dibben MS Excel MVP >G H >450.00 450.00 (G9) [quoted text clipped - 10 lines] >box is ticked. >Help anyone? - Gatsby 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 > Tools>Options>Calculation. > [quoted text clipped - 17 lines] > >Help anyone? - Gatsby > > 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  SignatureHth Kassie Kasselman > Thanks for answering Gord. > Automatic is ticked and this still is happening. It seems to be only when [quoted text clipped - 23 lines] > > >Help anyone? - Gatsby > > > 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 > 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, [quoted text clipped - 28 lines] > > > >Help anyone? - Gatsby > > > > That's a pleasure Gatsby! 'Your way' doen't work because something plus nothing is still something! SignatureHth Kassie Kasselman > 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 [quoted text clipped - 33 lines] > > > > >Help anyone? - Gatsby > > > > > 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 > 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 [quoted text clipped - 33 lines] > > > > >Help anyone? - Gatsby > > > > > Sorry I missed all the fun, but it sounds like you are cruising now! SignatureY > G H > 450.00 450.00 (G9) [quoted text clipped - 10 lines] > box is ticked. > Help anyone? - Gatsby |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.