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.
|