+ Reply to Thread
Results 1 to 4 of 4

using fill or autofill to recognize a numeric series in a formula

  1. #1
    Registered User
    Join Date
    08-26-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    11

    using fill or autofill to recognize a numeric series in a formula

    Hi: If I enter .5 in A1 and 1 in B1, autofill (handle) continues with the series .5, 1, 1.5 in C1, 2 in Da etc.
    If I enter =.5 in A1 and =1 in B1 it does not recognize the series.....
    I would appreciate any assistance. TIA.

    I'm using 2003 excel.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: using fill or autofill to recognize a numeric series in a formula

    If you enter .5 in A1, then use the RIGHT mouse button to drag down, a menu will pop up. Select 'Series...' and in the 'Step Value' field, enter .5 and click OK.

    - Moo

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: using fill or autofill to recognize a numeric series in a formula

    why would you want to use =1 anyway though?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    08-26-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: using fill or autofill to recognize a numeric series in a formula

    Here is the problem specifically: I want to drage these cells across the first row and use autofill to increase the boldfaced number by .5 in each cell. Autofill does not recognize the pattern and the 2.5 is static (i.e., continues to appear in each cell and must be changed manually. A bit of problem if you want to fill 1000 cells (A1-XX) in the row.

    (cellA1) =IF(AND($C$534="yes",$J$2=2.5),A495,"")

    (cell B1) =IF(AND($C$534="yes",$J$2=3),B495,"")

    (cell C1) =IF(AND($C$534="yes",$J$2=3.5),C495,"")

    etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1