+ Reply to Thread
Results 1 to 3 of 3

Thread: how to autofill only part of an "if" statement

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    West Virginia
    MS-Off Ver
    Excel 2003
    Posts
    3

    how to autofill only part of an "if" statement

    I have this formula =IF('Passeneger Checklist'!A$4=40908,'Passeneger Checklist'!$A$4)

    How do I auto fill only the 40908 to increase by one digit at a time using this formula?

    any help would be greatly appreciated

  2. #2
    Valued Forum Contributor Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds/Sheffield, England
    MS-Off Ver
    Excel 2003
    Posts
    1,031

    Re: how to autofill only part of an "if" statement

    Maybe

    =IF('Passeneger Checklist'!A$4=ROW(A40908),'Passeneger Checklist'!$A$4)
    Click the * below to say thanks

    Girls sleep with guys who use photoshop, but marry the ones who work with Excel

    Corduroy
    pillows: They're making headlines!

    Did you mean: recursion
    http://www.google.com/search?hl=en&q=recursion

  3. #3
    Registered User
    Join Date
    12-17-2011
    Location
    West Virginia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: how to autofill only part of an "if" statement

    OK im sorry I need to have the 40908 increase one digit every 5 rows

    =IF('Passeneger Checklist'!A$4=40908,'Passeneger Checklist'!$A$4)

    Is there a formula for that?

+ 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.2.0