Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function with Array Formula
Frank,
Thanks a lot for the good hints. I had to make a small modification, but it works !!! Appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get array formula to work in MATCH function | Excel Worksheet Functions | |||
Array Formula Using LOOKUP function. | Excel Worksheet Functions | |||
Array formula on INDEX function not working | Excel Worksheet Functions | |||
Use of Offset function in array formula | Excel Worksheet Functions | |||
Using AND function within an array formula | Excel Worksheet Functions |