Results 1 to 29 of 29

Multilple functions in nested IF

Threaded View

  1. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Multilple functions in nested IF

    OK, based on my interpretations then... perhaps

    =REPT("OK";IF(B7=1;AND(D7=1;E7=1);A7<INDEX({10000;25000;50000};MATCH(1;F7:H7;0))))
    (I'm assuming the syntax for the inline array is correct for your client locale - if not you will need to tell me where you're located)
    Last edited by DonkeyOte; 11-09-2009 at 07:27 AM. Reason: typo - 50000 rather than 5000

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