Results 1 to 29 of 29

Multilple functions in nested IF

Threaded View

Vestlink Multilple functions in nested... 11-09-2009, 05:08 AM
DonkeyOte Re: Multilple functions in... 11-09-2009, 06:35 AM
Vestlink Re: Multilple functions in... 11-09-2009, 07:02 AM
DonkeyOte Re: Multilple functions in... 11-09-2009, 07:12 AM
Vestlink Re: Multilple functions in... 11-09-2009, 07:14 AM
  1. #1
    Registered User
    Join Date
    11-30-2006
    Posts
    67

    Multilple functions in nested IF

    Hi.

    I have these 4 functions that i want to be able to "run" in a nested IF where the functions are used in this manner:

    =if((funct1 or funct2 or funct3 or funct4);"OK";"")

    funct1: =IF(AND(B7=1;D7=1;E7=1);"OK";"")
    funct2: =IF(AND(B7=0;C7=1;F7=1;A7<10000);"OK";"")
    funct3: =IF(AND(B7=0;C7=1;G7=1;A7<25000);"OK";"")
    funct4: =IF(AND(B7=0;C7=1;H7=1;A7<50000);"OK";"")

    Best regards

    Nicolai
    Last edited by Vestlink; 11-09-2009 at 07:41 AM. Reason: SOLVED

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