Results 1 to 7 of 7

Repeating if equation

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    Grimstad, Norway (Southern part)
    MS-Off Ver
    Excel 2010
    Posts
    48

    Repeating if equation

    Hi,

    I want to repeat the following equation 24 times with the changing values along the column down. After that I want to repeat the same equation again but again starting from "4" value only for A4, B4,C4,D4,G4,E4,J4,H4,L4,K4,I4 . That means equation starts

    =IF(O4>11,A4,IF(O4>10,B4,IF(O4>9,C4,IF(O4>8,D4,IF(O4>7,G4,IF(O4>6,E4,IF(O4>5,J4,IF(O4>4,H4,IF(O4>3,L4,IF(O4>2,K4,IF(O4>1,I4,F4)))))))))))

    equation after the 24 times

    =IF(O27>11,A27,IF(O27>10,B27,IF(O27>9,C27,IF(O27>8,D27,IF(O27>7,G27,IF(O27>6,E27,IF(O27>5,J27,IF(O27>4,H27,IF(O27>3,L27,IF(O27>2,K27,IF(O27>1,I27,F27)))))))))))

    Then again equation should start

    =IF(O28>11,A4,IF(O28>10,B4,IF(O28>9,C4,IF(O28>8,D4,IF(O28>7,G4,IF(O28>6,E4,IF(O28>5,J4,IF(O28>4,H4,IF(O28>3,L4,IF(O28>2,K4,IF(O28>1,I4,F4)))))))))))

    equation will end

    =IF(O51>11,A27,IF(O51>10,B27,IF(O51>9,C27,IF(O51>8,D27,IF(O51>7,G27,IF(O51>6,E27,IF(O51>5,J27,IF(O51>4,H27,IF(O51>3,L27,IF(O51>2,K27,IF(O51>1,I27,F27)))))))))))


    again it should start similar way.
    If possible please help me.I hv attached the sheet and done the same manually starting from cell 'P28'.
    Great many thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] dragging an equation but only changing one part of the equation
    By mufan in forum Excel General
    Replies: 7
    Last Post: 04-12-2012, 02:48 PM
  2. Replies: 4
    Last Post: 02-02-2012, 10:11 PM
  3. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  4. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  5. Equation Editor- problem when editing an equation
    By Gaby L. in forum Excel General
    Replies: 0
    Last Post: 09-27-2005, 05:05 PM

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