AND can't be used with arrays, but there are other ways to achieve that.

Please explain what you are trying to do, and we might be able to come up with something that works for you.

Why are you adding zero to Rates"Q337 ? Is it because that cell contains a number stored as a text value?

Pete