IF function with Array Formula
 

Hi,

I would like to know if there is an easy way to combine the following:

In Cell F7, there is an array formula:
{=(SUM(NOT($F$3:$O$3="X")*(F7:O7="X"))=0)}

In Cell F6, there is an IF statement:
IF(AND(IF(F7=TRUE,IF(Q7<"BAD",TRUE,FALSE),FALSE)) ,"Yes","No")

Is there a possibility to combine both of these formula into one ?
If not, a VBA function can probably do it, but how do you translate the array
formula shown above into a VBA function ?

Thanks a lot for your time & help.

IF function with Array Formula
 

Hi
try the following non array formula
=IF(AND(SUMMENPRODUKT(($F$3:$O$3="X")*(F7:O7="X")) 0,Q7="BAD"),"Yes","N
o")

--
Regards
Frank Kabel
Frankfurt, Germany


Moreaudjd wrote:
Hi,

I would like to know if there is an easy way to combine the
following:

In Cell F7, there is an array formula:
{=(SUM(NOT($F$3:$O$3="X")*(F7:O7="X"))=0)}

In Cell F6, there is an IF statement:
IF(AND(IF(F7=TRUE,IF(Q7<"BAD",TRUE,FALSE),FALSE)) ,"Yes","No")

Is there a possibility to combine both of these formula into one ?
If not, a VBA function can probably do it, but how do you translate
the array formula shown above into a VBA function ?

Thanks a lot for your time & help.

IF function with Array Formula
 

Auf englisch:

=IF(AND(SUMPRODUCT(($F$3:$O$3="X")*(F7:O7="X"))0, Q7="BAD"),"Yes","No")

(high school Deutsch!)


Frank Kabel wrote:

Hi
try the following non array formula
=IF(AND(SUMMENPRODUKT(($F$3:$O$3="X")*(F7:O7="X")) 0,Q7="BAD"),"Yes","N
o")

--
Regards
Frank Kabel
Frankfurt, Germany

Moreaudjd wrote:
Hi,

I would like to know if there is an easy way to combine the
following:

In Cell F7, there is an array formula:
{=(SUM(NOT($F$3:$O$3="X")*(F7:O7="X"))=0)}

In Cell F6, there is an IF statement:
IF(AND(IF(F7=TRUE,IF(Q7<"BAD",TRUE,FALSE),FALSE)) ,"Yes","No")

Is there a possibility to combine both of these formula into one ?
If not, a VBA function can probably do it, but how do you translate
the array formula shown above into a VBA function ?

Thanks a lot for your time & help.

--

Dave Peterson

IF function with Array Formula
 

Thanks Dave.
Got lost with my translation this evening

--
Regards
Frank Kabel
Frankfurt, Germany


Dave Peterson wrote:
Auf englisch:


=IF(AND(SUMPRODUCT(($F$3:$O$3="X")*(F7:O7="X"))0, Q7="BAD"),"Yes","No")

(high school Deutsch!)


Frank Kabel wrote:

Hi
try the following non array formula

=IF(AND(SUMMENPRODUKT(($F$3:$O$3="X")*(F7:O7="X")) 0,Q7="BAD"),"Yes","N
o")

--
Regards
Frank Kabel
Frankfurt, Germany

Moreaudjd wrote:
Hi,

I would like to know if there is an easy way to combine the
following:

In Cell F7, there is an array formula:
{=(SUM(NOT($F$3:$O$3="X")*(F7:O7="X"))=0)}

In Cell F6, there is an IF statement:
IF(AND(IF(F7=TRUE,IF(Q7<"BAD",TRUE,FALSE),FALSE)) ,"Yes","No")

Is there a possibility to combine both of these formula into one ?
If not, a VBA function can probably do it, but how do you translate
the array formula shown above into a VBA function ?

Thanks a lot for your time & help.

IF function with Array Formula
 

Frank,

Thanks a lot for the good hints.
I had to make a small modification, but it works !!!

Appreciated.