+ Reply to Thread
Results 1 to 2 of 2

Modify cell address within an IF statement

  1. 12-20-2011, 04:44 PM #1
    codyj1919
    codyj1919 is offline
    Registered User
    Join Date
    12-17-2011
    Location
    West Virginia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Modify cell address within an IF statement

    I have this formula

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

    I need the A40901 to increase 1 unit every sixth row.

    Is there a formula for that?

    ANY HELP WOULD BE GREATLY APPRECIATED
    Reply With QuoteRegister To Reply
  2. 12-20-2011, 05:30 PM #2
    Haseeb Avarakkan
    Haseeb Avarakkan is offline
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Modify cell address within an IF statement

    If you use this,

    =40900+INT((ROW(A1)-1)/5)+1

    On the starting will give you 40901, then every sixth row will increase by 1
    Regards,
    Haseeb Avarakkan
    __________________________________
    "Feedback is the breakfast of champions"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1