I am not sure what you are trying to do. If you are trying to just check if
G3 and H3 are true I would try
=and(G3,H3)

= AND(Used, Allowed)
will only give true if every cell in Used and Allowed has a true or is blank

"John Pinback" wrote:

> If I name an array G2:G90 Used and a second array H2:H90 Allowed and put
> logical values in these columns then I should be able to use the AND
> function but it gives me the wrong answer.
>
> For example, say G3 = TRUE and H3 = TRUE and I put the following formula in
> I3:
>
> = AND(Used, Allowed)
>
> I expect to see TRUE in I3 but I get FALSE.
>
> Thanks,
> Karl
> kwb AT dcm-va.com
>
>
>