Results 1 to 4 of 4

Combining Multiple IF/THEN Formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Combining Multiple IF/THEN Formulas

    Hello,
    Could anyone help to combine the following two formulas? Thank you.

    =IF(AND(N4<=J4,M4>=J4,F69="Odd"),1,IF(AND(N4>J4,M4>J4,N4<=I4,F69="Odd"),3,IF(AND(L4<K4,L4<B4,F69="Odd"),5,IF(AND(M4<J4,M4>B4,F69="Odd"),7,IF(AND(N4>=I4,M4>I4,F69="Odd"),9)))))
    AND

    =IF(AND(L4>=J4,M4<=J4,F69="Even"),2,IF(AND(L4<J4,M4<J4,L4>K4,F69="Even"),4,IF(AND(N4>I4,N4>B4,F69="Even"),6,IF(AND(M4>J4,M4<B4,F69="Even"),8,IF(AND(L4<K4,M4<K4,F69="Even"),10)))))
    Last edited by artiststevens; 12-09-2010 at 08:22 AM.

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