array with an if

[nisselyo]

Anyone have any idea why this array formula is not working properly?
{=MAX(IF(AND(AH53:AH76<>0,AC53:AC76>97),AH53:AH76))}
Without the and nested AND statement in the IF it works properly.
thanks.

 

[Richard Schollar]

AND won't return an array of results - it just returns a True or False. You should be able to write it as:

=MAX(IF(AH53:AH76<>0,IF(AC53:AC76>97,AH53:AH76)))

 

[nisselyo]

Thanks!