Multilple functions in nested IF

[Vestlink]

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

[DonkeyOte]

Nicolai, regards the F7:H7 - will a 1 always exist in this range (when B7=0 and C7=1) ?

If so can more than 1 ever exist in the range - ie F7 & H7 = 1 ?

[Vestlink]

Nicolai, regards the F7:H7 - will a 1 always exist in this range (when B7=0 and C7=1) ?

The answer is yes to this one.

If so can more than 1 ever exist in the range - ie F7 & H7 = 1 ?

The answer is no to this one. only 1.

Nicolai

[DonkeyOte]

thanks... couple more I should have asked -- just trying to ascertain the particulars so as to try and keep formula as lean as possible...

Q1: Can B7 be anything other than 1/0 ?

Q2: If B7 is 0 can C7 be anything other than 1 ?

[Vestlink]

q1: no. only 1/0
q2: only 1.

Nicolai

[DonkeyOte]

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)