This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks for the quick response - when I was typing it as I did in the example I was getting an error about an unrecognised variable "and" so assumed there had to be another way to do this. After you pointed out this was the correct way to do it I retyped the formula and this time it worked - must have been a typo in there!